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")), InitKeyType= InitKeyType.Attribute,
IsAutoCloseConnection = true
});
Db.Aop.OnLogExecuted = (sql, pars) => //SQL执行完事件
{
};
Db.Aop.OnLogExecuting = (sql, pars) => //SQL执行前事件
{
};
}
public SqlSugarClient Db;
public DbSet LoginDb { get { return new DbSet(Db); } }
}
public class DbSet : SimpleClient where T : class, new()
{
public DbSet(SqlSugarClient context) : base(context)
{
}
public List GetByIds(dynamic[] ids)
{
return Context.Queryable().In(ids).ToList(); ;
}
}
}