public void FindAllByPageTest() { using (var dbContext = new AdventureWorks2014DbContext()) { PagedList <Address> _finedAll = dbContext.FindAllByPage <Address, int>(null, c => c.ID, 10, 1); Assert.AreEqual(_finedAll.Count, 10); } }
public void FindAllTest() { using (var dbContext = new AdventureWorks2014DbContext()) { List <Address> _finedAll = dbContext.FindAll <Address>(); Assert.IsNotNull(_finedAll); } }
public void FindTest() { using (var dbContext = new AdventureWorks2014DbContext()) { Address _actual = dbContext.Find <Address>(1); Assert.IsNotNull(_actual); Assert.AreEqual(_actual.ID, 1); } }
public void DeleteTest() { using (var dbContext = new AdventureWorks2014DbContext()) { Address _fined = dbContext.Find <Address>(22); dbContext.Delete <Address>(_fined); _fined = dbContext.Find <Address>(22); Assert.IsNull(_fined); } }
public void UpdateTest() { using (var dbContext = new AdventureWorks2014DbContext()) { Address _actual = dbContext.Find <Address>(32529); string _expect = _actual.AddressLine1 + DateTime.Now.ToString("yyyyMMddHHmmss"); _actual.AddressLine1 = _expect; dbContext.Update <Address>(_actual); _actual = dbContext.Find <Address>(32529); Assert.AreEqual(_actual.AddressLine1, _expect); } }
public void InsertTest() { using (var dbContext = new AdventureWorks2014DbContext()) { Address _item = new Address(); _item.PostalCode = "78019"; _item.AddressLine1 = "Tianxin"; _item.City = "Changsha"; _item.StateProvinceID = 78; _item.PostalCode = "72229"; _item.rowguid = Guid.NewGuid(); Address _actual = dbContext.Insert <Address>(_item); Assert.IsNotNull(_actual); } }
public void SqlQueryTest() { using (var dbContext = new AdventureWorks2014DbContext()) { string _sql = @"SELECT [AddressID] as ID ,[AddressLine1] ,[AddressLine2] ,[City] ,[StateProvinceID] ,[PostalCode] ,[rowguid] ,[ModifiedDate] as CreateTime FROM[Person].[Address] where AddressID = @AddressID"; DbParameter _paramter = new SqlParameter("@AddressID", 32529); Address _actual = dbContext.SqlQuery <Address>(_sql, _paramter).FirstOrDefault(); Assert.IsNotNull(_actual); } }
public void DeleteTest() { using (AdventureWorks2014DbContext dbContext = new AdventureWorks2014DbContext()) { using (System.Data.Entity.DbContextTransaction tran = dbContext.Database.BeginTransaction()) { try { Address _fined = dbContext.Find <Address>(22); dbContext.Delete <Address>(_fined); _fined = dbContext.Find <Address>(22); Assert.IsNull(_fined); dbContext.SaveChanges(); tran.Commit(); } catch (Exception) { tran.Rollback(); } } } }
public void CommitTest() { using (var dbContext = new AdventureWorks2014DbContext()) { dbContext.BeginTransaction(); try { Address _item = new Address(); _item.PostalCode = "78019"; _item.AddressLine1 = "Tianxin"; _item.City = "Xiangtan"; _item.StateProvinceID = 78; _item.PostalCode = "72228"; _item.rowguid = Guid.NewGuid(); dbContext.Insert <Address>(_item); Address _fined = dbContext.Find <Address>(22); dbContext.Delete <Address>(_fined); dbContext.Commit(); } catch (Exception) { dbContext.Rollback(); } finally { Address _xiangtan = dbContext.FindAll <Address>(ent => ent.City == "Xiangtan").FirstOrDefault(); Assert.IsNull(_xiangtan); } } using (var dbContext = new AdventureWorks2014DbContext()) { dbContext.BeginTransaction(); try { dbContext.BeginTransaction(); Address _jiaxing = new Address(); _jiaxing.PostalCode = "78019"; _jiaxing.AddressLine1 = "Tianxin"; _jiaxing.City = "Jiaxing"; _jiaxing.StateProvinceID = 78; _jiaxing.PostalCode = "72228"; _jiaxing.rowguid = Guid.NewGuid(); dbContext.Insert <Address>(_jiaxing); Address _hangzhou = new Address(); _hangzhou.PostalCode = "78019"; _hangzhou.AddressLine1 = "Tianxin"; _hangzhou.City = "HangZhou"; _hangzhou.StateProvinceID = 78; _hangzhou.PostalCode = "72228"; _hangzhou.rowguid = Guid.NewGuid(); dbContext.Insert <Address>(_hangzhou); dbContext.Commit(); } catch (Exception) { dbContext.Rollback(); } finally { Address _hangZhou = dbContext.FindAll <Address>(ent => ent.City == "HangZhou").FirstOrDefault(); Assert.IsNotNull(_hangZhou); Address _jiaxing = dbContext.FindAll <Address>(ent => ent.City == "Jiaxing").FirstOrDefault(); Assert.IsNotNull(_jiaxing); } } }