ServiceStack.OrmLite

92 阅读 0 评论 61 点赞

我是靠谱客的博主冷傲魔镜，这篇文章主要介绍ServiceStack.OrmLite，现在分享给大家，希望可以做个参考。

LINQ很強大，不過有一點做不了，就是批量更新，刪除。而這個框架就實現了這個功能，令我喜出望外。

下載for sql server
PM> Install-Package ServiceStack.OrmLite.SqlServer -Version 4.0.30
http://www.nuget.org/packages/ServiceStack.OrmLite.SqlServer/4.0.30

https://github.com/ServiceStack/ServiceStack.OrmLite

1.Dictionary returns a Dictionary made from the first two columns:

复制代码Dictionary<int, string> trackIdNamesMap = db.Dictionary<int, string>(
"select Id, Name from Track")
Dictionary<int, string> trackIdNamesMap = db.Dictionary<int, string>(
"select Id, Name from Track")

2.Lookup returns an Dictionary<K, List<V>> made from the first two columns:

复制代码Dictionary<int, List<string>> albumTrackNames = db.Lookup<int, string>(
"select AlbumId, Name from Track")
Dictionary<int, List<string>> albumTrackNames = db.Lookup<int, string>(
"select AlbumId, Name from Track")

3.Reference Support, POCO style

OrmLite lets you Store and Load related entities in separate tables using [Reference] attributes in primary tables in conjunction with {Parent}Id property convention in child tables, e.g:

复制代码public class Customer
{

[AutoIncrement]
public int Id { get; set; }
public string Name { get; set; }

[Reference] // Save in CustomerAddress table
public CustomerAddress PrimaryAddress { get; set; }

[Reference] // Save in Order table
public List<Order> Orders { get; set; }
}
public class CustomerAddress
{

[AutoIncrement]
public int Id { get; set; }
public int CustomerId { get; set; } //`{Parent}Id` convention to refer to Customer
public string AddressLine1 { get; set; }
public string AddressLine2 { get; set; }
public string City { get; set; }
public string State { get; set; }
public string Country { get; set; }
}
public class Order
{

[AutoIncrement]
public int Id { get; set; }
public int CustomerId { get; set; } //`{Parent}Id` convention to refer to Customer
public string LineItem { get; set; }
public int Qty { get; set; }
public decimal Cost { get; set; }
}
public class Customer
{

[AutoIncrement]
public int Id { get; set; }
public string Name { get; set; }

[Reference] // Save in CustomerAddress table
public CustomerAddress PrimaryAddress { get; set; }

[Reference] // Save in Order table
public List<Order> Orders { get; set; }
}
public class CustomerAddress
{

[AutoIncrement]
public int Id { get; set; }
public int CustomerId { get; set; } //`{Parent}Id` convention to refer to Customer
public string AddressLine1 { get; set; }
public string AddressLine2 { get; set; }
public string City { get; set; }
public string State { get; set; }
public string Country { get; set; }
}
public class Order
{

[AutoIncrement]
public int Id { get; set; }
public int CustomerId { get; set; } //`{Parent}Id` convention to refer to Customer
public string LineItem { get; set; }
public int Qty { get; set; }
public decimal Cost { get; set; }
}