public void TestInsert1() { var db = new AdventureWorksDB(); var person = db.People.First(); Assert.IsNotNull(person); Assert.IsNotNull(person.BusinessEntityId); person = new Entities.Person(); Assert.IsNull(person.BusinessEntityId); person.PersonType = "GC"; person.NameStyle = false; person.FirstName = "Rick"; person.LastName = "Drizin"; person.EmailPromotion = 0; db.People.Add(person); int savedRecords = db.SaveChanges(); Assert.AreEqual(savedRecords, 1); Assert.IsNotNull(person.BusinessEntityId); var person2 = new AdventureWorksDB().Query <Entities.Person>("SELECT * FROM [Person].[Person] WHERE [BusinessEntityID]=@BusinessEntityID", new { person.BusinessEntityId }).Single(); Assert.IsNotNull(person2); Assert.AreEqual(person.FirstName, person2.FirstName); Assert.AreEqual(person.BusinessEntityId, person2.BusinessEntityId); }
public void TestMethod1() { var db = new AdventureWorksDB(); var person = db.People.First(); Assert.IsNotNull(person); Assert.IsNotNull(person.FirstName); var person2 = new AdventureWorksDB().Query <Entities.Person>("SELECT * FROM [Person].[Person] WHERE [BusinessEntityID]=@BusinessEntityID", new { person.BusinessEntityId }).Single(); Assert.IsNotNull(person2); Assert.AreEqual(person.FirstName, person2.FirstName); Assert.AreEqual(person.BusinessEntityId, person2.BusinessEntityId); }
public void Test2() { var db = new AdventureWorksDB(); var contacts = db.BusinessEntityContacts; var filtered = contacts.WherePropertyNotIn(p => p.ContactTypeId, new List <int?>() { 1, 2 }); var sql = filtered.ToString(); var result = filtered.ToList(); var result2 = new AdventureWorksDB().Query <Entities.BusinessEntityContact>(@" SELECT * FROM [Person].[BusinessEntityContact] WHERE [ContactTypeID] NOT IN (1,2)").ToList(); Assert.That(sql.Contains("NOT ([Extent1].[ContactTypeID] IN (1, 2))")); Assert.That(result.Count > 0); Assert.AreEqual(result.Count, result2.Count); System.Diagnostics.Debug.WriteLine(sql); }