Sandbox::https://github.com/yuailong/APIJSON.NET/blob/master/APIJSON.NET/APIJSON.NET/Data/DbContext.cs

Repository navigation

45 lines (40 loc) · 1.28 KB

using APIJSON.NET.Models;

using Microsoft.Extensions.Configuration;

using Microsoft.Extensions.Options;

using SqlSugar;

using System;

using System.Collections.Generic;

namespace APIJSON.NET

{

public class DbContext

{

public DbContext(IConfiguration options)

{

Db = new SqlSugarClient(new ConnectionConfig()

{

ConnectionString = options.GetConnectionString("ConnectionString"),

DbType = (DbType)Enum.Parse(typeof(SqlSugar.DbType), options.GetConnectionString("DbType")),

IsAutoCloseConnection = true,

InitKeyType= InitKeyType.Attribute

});

Db.Aop.OnLogExecuted = (sql, pars) => //SQL执行完事件

{

};

Db.Aop.OnLogExecuting = (sql, pars) => //SQL执行前事件

{

};

}

public SqlSugarClient Db;

public DbSet<Login> LoginDb { get { return new DbSet<Login>(Db); } }

}

public class DbSet<T> : SimpleClient<T> where T : class, new()

{

public DbSet(SqlSugarClient context) : base(context)

{

}

public List<T> GetByIds(dynamic[] ids)

{

return Context.Queryable<T>().In(ids).ToList(); ;

}