static void Main(string[] args)
{
var con = new SqlConnection(
" Data Source=192.168.13.62;Initial Catalog=SkyChen;Persist Security Info=True;User ID=sa;Password=123456789");
var user = new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988563330",
RealName = "陈珙",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
};
var insertResult = con.CommandSet <SysUser>().Insert(user);
Console.WriteLine("Insert添加数{0}", insertResult);
user.Email = "*****@*****.**";
user.SysUserid = Guid.NewGuid().ToString("N");
var ifNotExistsResult = con.CommandSet <SysUser>().IfNotExists(a => a.Email == "*****@*****.**").Insert(user);
Console.WriteLine("IfNotExists添加数{0}", ifNotExistsResult);
user.SysUserid = Guid.NewGuid().ToString("N");
var ifNotExistsResult2 = con.CommandSet <SysUser>().IfNotExists(a => a.Email == "*****@*****.**").Insert(user);
Console.WriteLine("IfNotExists2添加数{0}", ifNotExistsResult2);
var getResult = con.QuerySet <SysUser>().WithNoLock().Get();
getResult.Email = "*****@*****.**";
var updateModelResult = con.CommandSet <SysUser>().Update(getResult);
Console.WriteLine("Update添加数{0}", updateModelResult);
var updateDateTime = con.CommandSet <SysUser>().Where(a => a.SysUserid == getResult.SysUserid).Update(a => new SysUser
{
CreateDatetime = DateTime.Now
});
Console.WriteLine("updateDateTime添加数{0}", updateDateTime);
var batchInsert = new List <SysUser>
{
new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988562222",
RealName = "陈珙1",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
},
new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988561111",
RealName = "陈珙2",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
}
};
con.CommandSet <SysUser>().BatchInsert(batchInsert);
Console.WriteLine("BatchInsert done");
var countResult = con.QuerySet <SysUser>().WithNoLock().Where(a => a.Email == "*****@*****.**").Count();
Console.WriteLine("Count数{0}", countResult);
var toListResult = con.QuerySet <SysUser>().WithNoLock().Where(a => a.Email == "*****@*****.**")
.OrderBy(a => a.CreateDatetime).Top(2).Select(a => a.Email).ToList();
Console.WriteLine("ToList数{0}", toListResult.Count());
var listResult2 = con.QuerySet <SysUser>().WithNoLock().Where(a => a.Email == "*****@*****.**")
.OrderBy(a => a.CreateDatetime).Select(a => a.Email).PageList(2, 2);
Console.WriteLine("PageList:{0}", listResult2.TotalPage);
var updateResult4 = con.QuerySet <SysUser>().WithNoLock().Sum(a => a.UserStatus);
Console.WriteLine("Sum:{0}", updateResult4);
var updateResult5 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.Select(a => new SysUser {
Email = a.Email
})
.UpdateSelect(a => new SysUser {
Email = "*****@*****.**"
});
var updateResult6 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.OrderBy(a => a.CreateDatetime)
.Select(a => new SysUser {
Email = a.Email, Mobile = a.Mobile, Password = a.Password
}).PageList(1, 10);
var updateResult7 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.Top(2)
.Select(a => new SysUser {
Email = a.Email
})
.UpdateSelect(a => new SysUser {
Email = "*****@*****.**"
});
var deleteResult = con.CommandSet <SysUser>().Delete();
Console.WriteLine("Delete:{0}", deleteResult);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
using (var transaction = con.BeginTransaction())
{
con.CommandSet <SysUser>(transaction).Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "11111111111",
RealName = "陈珙",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
});
con.CommandSet <SysUser>(transaction).Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "22222222222",
RealName = "陈珙",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
});
transaction.Commit();
}
con.Transaction(tc =>
{
var SysUserid1 = tc.QuerySet <SysUser>().Where(a => a.Mobile == "18988561110").Select(a => a.SysUserid).Get();
var SysUserid2 = tc.QuerySet <SysUser>().Where(a => a.Mobile == "18988561111").Select(a => a.SysUserid).Get();
tc.CommandSet <SysUser>().Where(a => a.SysUserid == SysUserid1).Delete();
tc.CommandSet <SysUser>().Where(a => a.SysUserid == SysUserid2).Delete();
tc.CommandSet <SysUser>().Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "13536059332",
RealName = "大笨贞",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = EUserType.Super,
Password = "******"
});
}, ex =>
{
//do something
});
con.Dispose();
}
static void Main(string[] args)
{
var con = new SqlConnection(
" Data Source=192.168.13.53;Initial Catalog=SkyChen;Persist Security Info=True;User ID=sa;Password=123456789");
Enumerable.Range(0, 10000).ToList().AsParallel().ForAll(a =>
{
var con2 = new SqlConnection(
" Data Source=192.168.13.53;Initial Catalog=SkyChen;Persist Security Info=True;User ID=sa;Password=123456789");
var count = con2.Execute(@"UPDATE dbo.SYS_USER
SET USER_TYPE = USER_TYPE - 10
WHERE USER_TYPE >= 10
AND SYS_USERID = '2009b778a6bb426cbbb5e96b4d87ccea'; ");
Console.WriteLine(count);
});
con.Query <SysUser>(@"UPDATE dbo.SYS_USER
SET USER_TYPE = USER_TYPE - 10
WHERE USER_TYPE >= 10
AND SYS_USERID = '2009b778a6bb426cbbb5e96b4d87ccea'; ");
var qwe = new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988563330",
RealName = "陈珙",
SysUserid = "487c9dac0c094a31a89fef1a98bc4204",
UserName = "******",
UserStatus = 1,
UserType = 1,
Password = "******"
};
con.CommandSet <SysUser>().Where(a => a.SysUserid == qwe.SysUserid)
.Update(a => new SysUser {
Email = "*****@*****.**"
});
var list = con.QuerySet <SysUser>().ToList();
foreach (var VARIABLE in list)
{
con.CommandSet <SysUser>().Where(a => a.SysUserid == VARIABLE.SysUserid)
.Update(a => new SysUser {
Email = "*****@*****.**"
});
}
var insertResult2 = con.CommandSet <SysUser>().IfNotExists(a => a.Mobile == "18988563330").Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988563330",
RealName = "陈珙",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = 1,
Password = "******"
});
var insertResult = con.CommandSet <SysUser>().Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "18988561111",
RealName = "陈珙",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = 1,
Password = "******"
});
Console.WriteLine("添加数{0}", insertResult);
var countResult = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**").Count();
Console.WriteLine("查询个数{0}", insertResult);
var getResult = con.QuerySet <SysUser>().Get();
getResult.Email = "*****@*****.**";
var updateModelResult = con.CommandSet <SysUser>().Update(getResult);
var listResult = con.QuerySet <SysUser>().OrderBy(a => a.CreateDatetime).Select(a => a.Email).ToList();
var listResult2 = con.QuerySet <SysUser>().OrderBy(a => a.CreateDatetime).Top(2).Select(a => a.Email).ToList();
var updateResult = con.CommandSet <SysUser>().Where(a => a.SysUserid == "487c9dac0c094a31a89fef1a98bc4204")
.Update(a => new SysUser {
Email = "*****@*****.**"
});
getResult.Email = "*****@*****.**";
var updateResult2 = con.CommandSet <SysUser>().Where(a => a.Email == "*****@*****.**").Update(getResult);
var updateResult3 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**").OrderBy(b => b.Email)
.Top(10).Select(a => a.Email).ToList();
var updateResult8 = con.QuerySet <SysUser>().OrderBy(b => b.Email).Top(10).ToList();
var updateResult4 = con.QuerySet <SysUser>().Sum(a => a.UserStatus);
var updateResult5 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.Select(a => new SysUser {
Email = a.Email
})
.UpdateSelect(a => new SysUser {
Email = "*****@*****.**"
});
var updateResult6 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.OrderBy(a => a.CreateDatetime)
.Select(a => new SysUser {
Email = a.Email, Mobile = a.Mobile, Password = a.Password
}).PageList(1, 10);
var updateResult7 = con.QuerySet <SysUser>().Where(a => a.Email == "*****@*****.**")
.OrderBy(a => a.CreateDatetime)
.Select(a => new SysUser {
Email = a.Email
})
.UpdateSelect(a => new SysUser {
Email = "*****@*****.**"
});
con.Transaction(tc =>
{
var SysUserid1 = tc.QuerySet <SysUser>().Where(a => a.Mobile == "18988561110").Select(a => a.SysUserid).Get();
var SysUserid2 = tc.QuerySet <SysUser>().Where(a => a.Mobile == "18988561111").Select(a => a.SysUserid).Get();
tc.CommandSet <SysUser>().Where(a => a.SysUserid == SysUserid1).Delete();
tc.CommandSet <SysUser>().Where(a => a.SysUserid == SysUserid2).Delete();
tc.CommandSet <SysUser>().Insert(new SysUser
{
CreateDatetime = DateTime.Now,
Email = "*****@*****.**",
Mobile = "13536059332",
RealName = "大笨贞",
SysUserid = Guid.NewGuid().ToString("N"),
UserName = "******",
UserStatus = 1,
UserType = 1,
Password = "******"
});
});
con.Dispose();
}
