public int Update()
{
var test = T_Test.SingleOrDefault("where Name=@0", "aaaa");
test.Remark = "备注-修改";
return(test.Update());
}
public List <TestEntity> Query()
{
var list = T_Test.Query("");
List <TestEntity> aa = EntityConvertTools.CopyToList <T_Test, TestEntity>(list.ToList());
return(aa);
}
public int Insert()
{
T_Test test = new T_Test();
test.Name = "aaaa";
test.Remark = "备注";
int count = QSDMS_SQLDB.GetInstance().Execute("insert into t_test(name,remark) values(@0,@1)", "aaaa", "备注111");
return(count);
}
static void Main(string[] args)
{
Console.WriteLine("测试vs提交");
DbContext db = new DbContext();
//新增
//var model = new T_Test { UserName = "******", Pwd = "123456", BirthDate = DateTime.Now, InUse = false };
//db.Save(model);
//Console.WriteLine("写入成功");
//获取数据
var info = db.SingleOrDefault <T_Test>(1);
Console.WriteLine(info.UserName);
//更新数据
//方式1
db.Update <T_Test>("SET UserName = '******' WHERE ID = @0", 1);
//方式2
var model2 = new T_Test
{
ID = 1,
UserName = "******",
Pwd = "123456",
BirthDate = DateTime.Now,
InUse = false
};
var updateColumns = new List <string>()
{
"UserName", "BirthDate", "InUse"
};
db.Update(model2, updateColumns);
//删除
db.Delete <T_Test>(4);
Console.ReadKey();
}
public void Detele()
{
T_Test.Delete("where name=@0", "aaaa");
}
