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);
}
