public void Contains15(string context)
{
var arr = Parent1.Take(2).ToArray();
using (var db = GetDataContext(context))
AreEqual(
from p in Child where arr.Contains(p.Parent1) select p,
from p in db.Child where arr.Contains(p.Parent1) select p);
}
public void Contains9([DataContexts] string context)
{
var arr = Parent1.Take(2).ToArray();
using (var db = GetDataContext(context))
AreEqual(
from p in Parent1 where arr.Contains(p) select p,
from p in db.Parent1 where arr.Contains(p) select p);
}
public void TestObjectLiteralFieldImplementingInterface()
{
Child1 c = new Child1 {
Name = "name"
};
Parent1 p = c;
Assert.AreEqual("name", p.Name);
Assert.AreEqual("name", c.Name);
}
public void Contains14([DataSources] string context)
{
var ps = Parent1.OrderBy(p => p.ParentID).Take(2).ToArray();
using (var db = GetDataContext(context))
foreach (var p in ps)
{
TestContains(db, p);
}
}
internal void AddAncestors(HashSet <GraphNode> set)
{
if (Parent1 != null && !set.Contains(Parent1))
{
set.Add(Parent1);
Parent1.AddAncestors(set);
}
if (Parent2 != null && !set.Contains(Parent2))
{
set.Add(Parent2);
Parent2.AddAncestors(set);
}
}
public void Delete2()
{
ForEachProvider(db =>
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Delete(parent);
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Where(p => p.ParentID == parent.ParentID).Delete());
Assert.AreEqual(0, db.Parent.Count(p => p.ParentID == parent.ParentID));
});
}
public void Delete2()
{
ForEachProvider(db =>
{
var parent = new Parent1 {
ParentID = 1001, Value1 = 1001
};
db.Delete(parent);
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Where(p => p.ParentID == parent.ParentID).Delete());
Assert.AreEqual(0, db.Parent.Count(p => p.ParentID == parent.ParentID));
});
}
public void Delete2([DataSources] string context)
{
using (var db = GetDataContext(context))
using (new RestoreBaseTables(db))
{
var parent = new Parent1 {
ParentID = 1001, Value1 = 1001
};
db.Delete(parent);
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
var cnt = db.Parent.Where(p => p.ParentID == parent.ParentID).Delete();
Assert.AreEqual(1, cnt);
Assert.AreEqual(0, db.Parent.Count(p => p.ParentID == parent.ParentID));
}
}
public void OrderBySelectMany2([DataSources] string context)
{
using (var db = GetDataContext(context))
{
var expected =
from p in Parent1.OrderBy(p => p.ParentID)
from c in Child.OrderBy(c => c.ChildID)
where p.ParentID == c.Parent1 !.ParentID
select new { p.ParentID, c.ChildID };
var result =
from p in db.Parent1.OrderBy(p => p.ParentID)
from c in db.Child.OrderBy(c => c.ChildID)
where p == c.Parent1
select new { p.ParentID, c.ChildID };
Assert.IsTrue(result.ToList().SequenceEqual(expected));
}
}
public void OrderBySelectMany2()
{
var expected =
from p in Parent1.OrderBy(p => p.ParentID)
from c in Child.OrderBy(c => c.ChildID)
where p.ParentID == c.Parent1.ParentID
select new { p.ParentID, c.ChildID };
ForEachProvider(db =>
{
var result =
from p in db.Parent1.OrderBy(p => p.ParentID)
from c in db.Child.OrderBy(c => c.ChildID)
where p == c.Parent1
select new { p.ParentID, c.ChildID };
Assert.IsTrue(result.ToList().SequenceEqual(expected));
});
}
public void Update1([DataContexts] string context)
{
using (var db = GetDataContext(context))
{
try
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Parent.Delete(p => p.ParentID > 1000);
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count (p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Update(p => p.ParentID == parent.ParentID, p => new Parent { ParentID = p.ParentID + 1 }));
Assert.AreEqual(1, db.Parent.Count (p => p.ParentID == parent.ParentID + 1));
}
finally
{
db.Child.Delete(c => c.ChildID > 1000);
}
}
}
public void Update2()
{
ForEachProvider(db =>
{
try
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Parent.Delete(p => p.ParentID > 1000);
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Where(p => p.ParentID == parent.ParentID).Update(p => new Parent { ParentID = p.ParentID + 1 }));
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID + 1));
}
finally
{
db.Child.Delete(c => c.ChildID > 1000);
}
});
}
public void Delete1(string context)
{
using (var db = GetDataContext(context))
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Delete(parent);
db.Insert(parent);
try
{
Assert.AreEqual(1, db.Parent.Count (p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Delete(p => p.ParentID == parent.ParentID));
Assert.AreEqual(0, db.Parent.Count (p => p.ParentID == parent.ParentID));
}
finally
{
db.Delete(parent);
}
}
}
public void Delete1()
{
ForEachProvider(db =>
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Delete(parent);
try
{
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count (p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Delete(p => p.ParentID == parent.ParentID));
Assert.AreEqual(0, db.Parent.Count (p => p.ParentID == parent.ParentID));
}
finally
{
db.Delete(parent);
}
});
}
public void Delete2(string context)
{
using (var db = GetDataContext(context))
{
var parent = new Parent1 {
ParentID = 1001, Value1 = 1001
};
db.Delete(parent);
db.Insert(parent);
try
{
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Where(p => p.ParentID == parent.ParentID).Delete());
Assert.AreEqual(0, db.Parent.Count(p => p.ParentID == parent.ParentID));
}
finally
{
db.Delete(parent);
}
}
}
public void Delete1()
{
ForEachProvider(db =>
{
var parent = new Parent1 {
ParentID = 1001, Value1 = 1001
};
db.Delete(parent);
try
{
db.Insert(parent);
Assert.AreEqual(1, db.Parent.Count(p => p.ParentID == parent.ParentID));
Assert.AreEqual(1, db.Parent.Delete(p => p.ParentID == parent.ParentID));
Assert.AreEqual(0, db.Parent.Count(p => p.ParentID == parent.ParentID));
}
finally
{
db.Delete(parent);
}
});
}
public Parent1(Parent1 toCopyFrom)
{
Field1 = toCopyFrom.Field1;
Field2 = toCopyFrom.Field2;
}
public void Update8([DataContexts] string context)
{
using (var db = GetDataContext(context))
{
try
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Parent.Delete(p => p.ParentID > 1000);
db.Insert(parent);
parent.Value1++;
db.Update(parent);
Assert.AreEqual(1002, db.Parent.Single(p => p.ParentID == parent.ParentID).Value1);
}
finally
{
db.Child.Delete(c => c.ChildID > 1000);
}
}
}
public static void Foo()
{
return(Parent1.Foo());
}
public void Contains14()
{
var ps = Parent1.OrderBy(p => p.ParentID).Take(2).ToArray();
ForEachProvider(db => Array.ForEach(ps, p => TestContains(db, p)));
}
void TestContains(ITestDataContext db, Parent1 parent)
{
Assert.AreEqual(
Parent1.Where(p => p.ParentID == 1).Contains(parent),
db.Parent1.Where(p => p.ParentID == 1).Contains(parent));
}
public void Update8()
{
ForEachProvider(db =>
{
try
{
var parent = new Parent1 { ParentID = 1001, Value1 = 1001 };
db.Parent.Delete(p => p.ParentID > 1000);
db.Insert(parent);
parent.Value1++;
db.Update(parent);
Assert.AreEqual(1002, db.Parent.Single(p => p.ParentID == parent.ParentID).Value1);
}
finally
{
db.Child.Delete(c => c.ChildID > 1000);
}
});
}
public GuiChild1(Parent1 toCopyFrom) : base(toCopyFrom)
{
}
void TestContains(ITestDataContext db, Parent1 parent)
{
Assert.AreEqual(
Parent1.Where(p => p.ParentID == 1).Contains(parent),
db.Parent1.Where(p => p.ParentID == 1).Contains(parent));
}
