我的嫂嫂十九岁,节选,剿匪敢死队
新年之际,给大家介绍个我自己开发的orm类库insql。ta是一个轻量级的.net orm类库 . 对象映射基于dapper , sql配置灵感来自于mybatis。简单优雅性能是ta的追求。
|
以下可跳过 : )
package | nuget install |
---|---|
insql | install-package insql |
insql.mysql | install-package insql.mysql |
insql.oracle | install-package insql.oracle |
insql.postgresql | install-package insql.postgresql |
insql.sqlite | install-package insql.sqlite |
add insql
public void configureservices(iservicecollection services) { services.addinsql(); services.addinsqldbcontext<userdbcontext>(options => { options.usesqlite(this.configuration.getconnectionstring("sqlite")); }); }
create dbcontext
public class userdbcontext : insql.dbcontext { public userdbcontext(insql.dbcontextoptions<userdbcontext> options) : base(options) { } public ienumerable<userinfo> getuserlist(string username) { //sqlid = "getuserlist" //sqlparam is plainobject or idictionary<string,object> return this.query<userinfo>(nameof(getuserlist), new { username, usergender = gender.w }); } public void insertuser(userinfo info) { var userid = this.executescalar<int>(nameof(insertuser),info); info.userid = userid; } public void updateuserselective(userinfo info) { this.execute(nameof(updateuserselective), info); } } //user model public class userinfo { public int userid { get; set; } public string username { get; set; } public gender? usergender { get; set; } } public enum gender { m, w }
create dbcontext.insql.xml
创建
userdbcontext.insql.xml
文件并且修改这个文件的属性为嵌入式文件
类型 .insql type
与userdbcontext
类型对应.
<insql type="example.domain.contexts.userdbcontext,example.domain" > <sql id="selectusercolumns"> select user_id as userid,user_name as username,user_gender as usergender from user_info </sql> <select id="getuserlist"> <include refid="selectusercolumns" /> <where> <if test="username != null"> <bind name="likeusername" value="'%' + username + '%'" /> user_name like @likeusername </if> <if test="usergender != null and usergender != 'm' "> and user_gender = @usergender </if> </where> order by user_id </select> <insert id="insertuser"> insert into user_info (user_name,user_gender) values (@username,@usergender); select last_insert_rowid() from user_info; </insert> <update id="updateuser"> update user_info set user_name=@username,user_gender=@usergender where user_id = @userid </update> <update id="updateuserselective"> update user_info <set> <if test="username != null"> user_name=@username, </if> <if test="usergender != null"> user_gender=@usergender </if> </set> where user_id = @userid </update> </insql>
use dbcontext
public class valuescontroller : controllerbase { private readonly userdbcontext userdbcontext; public valuescontroller(userdbcontext userdbcontext) { this.userdbcontext = userdbcontext; } [httpget] public actionresult<ienumerable<string>> get() { //可以这样简单的使用事务 this.userdbcontext.dowithtransaction(() => { this.userdbcontext.insertuser(new domain.userinfo { username = "lovew", usergender = domain.gender.m }); this.userdbcontext.updateuserselective(new domain.userinfo { userid = 1, username = "lovewww", }); }); var list = this.userdbcontext.getuserlist("love"); } }
create common dbcontext
public class sqlitedbcontext<t> : dbcontext where t : class { public sqlitedbcontext(dbcontextoptions<sqlitedbcontext<t>> options) : base(options) { } protected override void onconfiguring(dbcontextoptions options) { var configuration = options.serviceprovider.getrequiredservice<iconfiguration>(); //t type mapping to insql.xml type options.usesqlresolver<t>(); options.usesqlite(configuration.getconnectionstring("sqlite")); } }
create domain service
public interface iuserservice { ienumerable<userinfo> getuserlist(string username,gender? usergender); } public class userservice : iuserservice { private readonly dbcontext dbcontext; //t is userservice public userservice(sqlitedbcontext<userservice> dbcontext) { this.dbcontext = dbcontext; } public ienumerable<userinfo> getuserlist(string username, gender? usergender) { return this.dbcontext.query<userinfo>(nameof(getuserlist), new { username, usergender }); } }
create service.insql.xml
创建
userservice.insql.xml
文件并且修改这个文件的属性为嵌入式文件
类型 .insql type
与userservice
类型对应.
<insql type="example.domain.services.userservice,example.domain" > <sql id="selectusercolumns"> select user_id as userid,user_name as username,user_gender as usergender from user_info </sql> <select id="getuserlist"> <include refid="selectusercolumns" /> <where> <if test="username != null"> <bind name="likeusername" value="'%' + username + '%'" /> user_name like @likeusername </if> <if test="usergender != null "> and user_gender = @usergender </if> </where> order by user_id </select> </insql>
add insql
public void configureservices(iservicecollection services) { services.addinsql(); services.addscoped(typeof(dbcontextoptions<>)); services.addscoped(typeof(sqlitedbcontext<>)); services.addscoped<iuserservice, userservice>(); }
use domain service
public class valuescontroller : controllerbase { private readonly iuserservice userservice; public valuescontroller(iuserservice userservice) { this.userservice = userservice; } [httpget] public actionresult<ienumerable<string>> get() { var list = this.userservice.getuserlist("11", domain.gender.m); } }
@谢谢大家支持!
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
Net Core Web Api项目与在NginX下发布的方法
asp.net core3.1 引用的元包dll版本兼容性问题解决方案
IdentityServer4实现.Net Core API接口权限认证(快速入门)
ASP.NET Core MVC通过IViewLocationExpander扩展视图搜索路径的实现
网友评论