public void Code_First_友好模式_修改表()
{
var ef = EsyDbFuncs.New()
.CodeFirstInit(true, typeof(MK_Skin), typeof(MK_User));
Console.WriteLine($"表更新数量:{ef}");
}
public void Code_First_粗暴模式_先删再键表_()
{
var ef = EsyDbFuncs.New()
.CodeFirstInitgg(false, typeof(MK_Skin_), typeof(MK_User_));
Console.WriteLine($"表更新数量:{ef}");
}
public void Code_First_删除备份表()
{
var droplsitsql =
@"SELECT 'drop table ' + TABLE_NAME + ';' FROM INFORMATION_SCHEMA.TABLES
WHERE(TABLE_TYPE = 'BASE TABLE' OR TABLE_TYPE = 'VIEW') and TABLE_NAME like 'bak_%' ";
var list = EsyDbFuncs.New().Query <string>(droplsitsql, null).ToList();
Console.WriteLine(list.Count());
var dropsql = string.Join("", list);
var ef = EsyDbFuncs.New().Query(dropsql, null);
}
public void Dapper_存储过程2种方式()
{
using (var conn = EsyDbFuncs.New().GetConn())
{
var trans = conn.BeginTransaction();
try
{
// 1
conn.Query("EXEC sp_rename 'model_xxx.[Pie666]', 'Pie333' , 'COLUMN'", transaction: trans);
// 2
//EXEC sp_rename 'model_xxx.[Pie2]', 'Pie666' , 'COLUMN'
//@objname,@newname,@objtype
var x = conn.Query("sp_rename", new { objname = "model_xxx.[Pie2]", newname = "Pie666", objtype = "COLUMN" }, trans, commandType: System.Data.CommandType.StoredProcedure);
}
catch { }
}
}
