public void SimpleTest() { string sql = @"SELECT TOP 10 * FROM fei_users"; using (var context = new SkyDbContext()) { var results = context.Query <FeiUsers>(sql); } }
public void ComprehensiveTest() { int bcid = (new Random()).Next(100, 1000); string name = DateTime.Now.Ticks.ToString(); string sql = @"SELECT uid AS id ,bcid ,username ,email ,mobile ,password ,mallagid ,salt ,userstatus ,created_time ,modified_time ,actionlist FROM fei_users WHERE bcid = @bcid"; using (var context = new SkyDbContext()) { int insertCount = context.Users.AsInsertable(new FeiUsers { Bcid = bcid, Username = name, Userstatus = 1, Mobile = "18980861011", Email = "*****@*****.**", Password = "******", Salt = string.Empty, CreatedTime = DateTime.Now, ModifiedTime = DateTime.Now }).ExecuteCommand(); var entry = context.QuerySingle <FeiUsers>(sql, new { bcid, name }); entry.Userstatus = 2; entry.ModifiedTime = DateTime.Now; int updateCount = context.Users.AsUpdateable(entry) .Set(x => new { x.Userstatus, x.ModifiedTime }) .ExecuteCommand(); int deleteCount = context.Users.AsDeleteable(entry) .ExecuteCommand(); Assert.AreEqual(insertCount, updateCount); Assert.AreEqual(insertCount, deleteCount); } }
public void JoinPagingTest() { string sql = @"SELECT x.* FROM fei_users x INNER JOIN fei_userdetails y ON x.uid = y.uid WHERE x.userstatus = 1"; using (var context = new SkyDbContext()) { var results = context.Query <FeiUsers>(sql, 0, 10); } }