分享.NET 轻量级的ORM
ORM
https://github.com/StackExchange/dapper-dot-net
http://fluentdata.codeplex.com/
https://github.com/toptensoftware/PetaPoco
https://github.com/schotime/NPoco
https://github.com/ServiceStack/ServiceStack.OrmLite
使用Dapper
1.已经在项目中使用了Dapper,感觉还行,基本可以满足需求
2.使用Dapper一段时间,AnsiStringFixedLength 与AnsiString区别 http://stackoverflow.com/search?page=1&tab=votes&q=dapper
3.扩展Dapper : https://github.com/tmsmith/Dapper-Extensions or Dapper.Rainbow VS Dapper.Contrib
影响执行计划
Ansi Strings and varchar
Dapper supports varchar params, if you are executing a where clause on a varchar column using a param be sure to pass it in this way:
Query<Thing>("select * from Thing where Name = @Name", new {Name = new DbString { Value = "abcde", IsFixedLength = true, Length = 10, IsAnsi = true });
List Support
Dapper allow you to pass in IEnumerable and will automatically parameterize your query.
For example:
connection.Query<int>("select * from (select 1 as Id union all select 2 union all select 3) as X where Id in @Ids", new { Ids = new int[] { 1, 2, 3 });
Will be translated to:
select * from (select 1 as Id union all select 2 union all select 3) as X where Id in (@Ids1, @Ids2, @Ids3)" // @Ids1 = 1 , @Ids2 = 2 , @Ids2 = 3
_db.Query<Users>("SELECT * FROM dbo.Users WHERE id IN @ids ",new { ids = IDs.ToArray()}).ToList();
Refer:
Dapper.Rainbow VS Dapper.Contrib
http://stackoverflow.com/questions/10030285/dapper-rainbow-vs-dapper-contrib
Using Dapper QueryMultiple in Oracle
http://stackoverflow.com/questions/18772781/using-dapper-querymultiple-in-oracle
SELECT * FROM X WHERE id IN (…) with Dapper ORM
http://stackoverflow.com/questions/8388093/select-from-x-where-id-in-with-dapper-orm
扩展Dapper
https://github.com/tmsmith/Dapper-Extensions
Any Question
http://stackoverflow.com/search?page=1&tab=votes&q=dapper
最新文章
- STM32学习笔记(五) USART异步串行口输入输出(轮询模式)
- mysql insert一条记录后怎样返回创建记录的主键id,last_insert_id(),selectkey
- CDN的原理以及其中的一些技术
- JS 去除字符串中的空格
- AutoGenSystem
- iOS之NSURLSessionDownloadTask下载
- FZU 2129 子序列个数 (动态规划)
- OSG消锯齿
- C#打开php链接传参然后接收返回值
- 201521123063 《Java程序设计》 第8周学习总结
- Linux显示系统的诊断信息
- Codeforces Round #419 Div. 1
- ActiveMQ 事务和XA
- OpenWrt路由器通过LuCI界面实现Guest SSID功能
- ubuntu journalctl — 检索 systemd 日志
- HDU1423 Greatest Common Increasing Subsequence
- 【转】每天一个linux命令(56):netstat命令
- MySQL 5.7.17 Group Relication(组复制)搭建手册【转】
- linux sort中文失效问题的解决
- ZIP压缩格式与RAR压缩格式