static void Main(string[] args)
{
XpoDefault.ConnectionString = MSSqlConnectionProvider.GetConnectionString(".", "sa", "123", "testdb");
Session
sessionI = new Session(),
sessionII;
UnitOfWork
unitOfWorkI;
XPMemberInfo
memberInfo;
XPCollection
xpCollectionI,
xpCollectionII;
XPCollection <Staff>
xpCollectionStaff;
CriteriaOperator
criteria;
TestMaster
tmpTestMaster,
tmpTestMasterII;
TestDetail
tmpTestDetail,
tmpTestDetailII;
TestDE
tmpTestDE = null,
tmpTestDEII = null;
int
tmpInt;
string
tmpString;
XPClassInfo
testMasterClassInfo = sessionI.GetClassInfo <TestMaster>(),
testDetailClassInfo = sessionI.GetClassInfo <TestDetail>(),
staffClassInfo = sessionI.GetClassInfo <Staff>();
Victim
tmpVictim;
#if TEST_PREFETCH_COLLECTION
if ((tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(2L)) != null)
{
foreach (var detail in tmpTestMaster.Details)
{
Debug.WriteLine($"Id: {detail.Id}");
}
}
if ((tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L)) != null && (memberInfo = testMasterClassInfo.GetMember(nameof(TestMaster.Details))).MemberType.IsSubclassOf(typeof(XPBaseCollection)))
{
if (memberInfo.GetValue(tmpTestMaster) is XPCollection <TestDetail> xpCollectionTestDetails)
{
if (((IXPPrefetchableAssociationList)xpCollectionTestDetails).NeedPrefetch())
{
criteria = new BinaryOperator(new OperandProperty(nameof(TestDetail.Master)), new OperandValue(tmpTestMaster.Id), BinaryOperatorType.Equal);
var details = sessionI.GetObjects(testDetailClassInfo, criteria, null, 0, true, false);
((IXPPrefetchableAssociationList)xpCollectionTestDetails).FinishPrefetch(details);
if (!xpCollectionTestDetails.IsLoaded)
{
xpCollectionTestDetails.Load();
}
}
}
foreach (var detail in tmpTestMaster.Details)
{
Debug.WriteLine($"Id: {detail.Id}");
}
}
#endif
#if TEST_GENERICS
xpCollectionI = new XPCollection(sessionI, typeof(Staff));
//xpCollectionStaff = xpCollectionI as XPCollection<Staff>; // Error CS0039 Cannot convert type 'DevExpress.Xpo.XPCollection' to 'DevExpress.Xpo.XPCollection<TestCollection.Db.Staff>' via a reference conversion, boxing conversion, unboxing conversion, wrapping conversion, or null type conversion
Type genericXPCollectionStaff = typeof(XPCollection <>).MakeGenericType(staffClassInfo.ClassType);
xpCollectionStaff = Activator.CreateInstance(genericXPCollectionStaff, sessionI) as XPCollection <Staff>;
xpCollectionStaff = new XPCollection <Staff>(sessionI);
genericXPCollectionStaff = xpCollectionStaff.GetType();
if (genericXPCollectionStaff.IsGenericType)
{
var genericTypeDefinition = genericXPCollectionStaff.GetGenericTypeDefinition();
if (genericTypeDefinition == typeof(XPCollection <>))
{
Type type = genericXPCollectionStaff.GetGenericArguments()[0];
//type = genericXPCollectionStaff.GetProperty("Item").PropertyType;
type = genericXPCollectionStaff.GetTypeInfo().GenericTypeArguments[0];
}
var xpBaseCollection = (XPBaseCollection)xpCollectionStaff;
}
var customCollectionStaff = new CustomCollection <Staff>(sessionI);
var customCollection = (XPBaseCollection)customCollectionStaff;
Type type1 = xpCollectionI.GetType();
Type elementType = typeof(object);
Type type2 = typeof(IEnumerable <>).MakeGenericType(elementType);
Type type3 = typeof(IQueryable <>).MakeGenericType(elementType);
bool flag = type2.IsAssignableFrom(type1); // IEnumerable<> false
flag = type3.IsAssignableFrom(type1); // IQueryable<> false
MethodInfo method1 = (flag ? queryableDistinctInfo : enumerableDistinctInfo).MakeGenericMethod(elementType);
MethodInfo method2 = (flag ? queryableOfTypeInfo : enumerableOfTypeInfo).MakeGenericMethod(elementType);
ParameterExpression parameterExpression = Expression.Parameter(typeof(object), "dataSource");
UnaryExpression unaryExpression = Expression.Convert((Expression)parameterExpression, flag ? type3 : type2);
var expr = Expression.Lambda <Func <object, object> >((Expression)(true ? Expression.Call(method1, (Expression)unaryExpression) : Expression.Call(method1, (Expression)Expression.Call(method2, (Expression)unaryExpression))), new ParameterExpression[1]
{
parameterExpression
});
var func = expr.Compile();
//var result = func(xpCollectionI);
type1 = xpCollectionStaff.GetType();
flag = type2.IsAssignableFrom(type1); // IEnumerable<> true
flag = type3.IsAssignableFrom(type1); // IQueryable<> false
var result = func(xpCollectionStaff);
#endif
#if TEST_SORTING
xpCollectionI = new XPCollection(sessionI, typeof(Staff), null, new SortProperty("Dep", SortingDirection.Ascending), new SortProperty("Name", SortingDirection.Ascending));
foreach (var item in xpCollectionI.OfType <Staff>())
{
Debug.WriteLine($"{{Dep:{item.Dep}, Name:\"{item.Name}\"}}");
}
xpCollectionII = new XPCollection(sessionI, typeof(Staff));
xpCollectionII.Sorting = new SortingCollection {
new SortProperty("Dep", SortingDirection.Ascending), new SortProperty("Name", SortingDirection.Ascending)
};
foreach (var item in xpCollectionII.OfType <Staff>())
{
Debug.WriteLine($"{{Dep:{item.Dep}, Name:\"{item.Name}\"}}");
}
#endif
#if TEST_COLLECTION_FROM_COLLECTION
var baseCollection = new XPCollection <Victim>(sessionI);
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
var falseCollection = new XPCollection(baseCollection, new BinaryOperator(new OperandProperty("FBit"), new OperandValue(false), BinaryOperatorType.Equal));
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
var trueCollection = new XPCollection(baseCollection, new BinaryOperator(new OperandProperty("FBit"), new OperandValue(true), BinaryOperatorType.Equal));
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
if ((tmpVictim = ((IBindingList)falseCollection).AddNew() as Victim) != null)
{
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.FBit = false;
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.Save();
baseCollection.Reload();
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
}
if ((tmpVictim = ((IBindingList)falseCollection).AddNew() as Victim) != null)
{
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.FBit = true;
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.Save();
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in falseCollection)
{
Debug.WriteLine($"falseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
}
if ((tmpVictim = ((IBindingList)trueCollection).AddNew() as Victim) != null)
{
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.FBit = true;
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.Save();
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
}
if ((tmpVictim = ((IBindingList)trueCollection).AddNew() as Victim) != null)
{
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.FBit = false;
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
tmpVictim.Save();
foreach (var item in baseCollection)
{
Debug.WriteLine($"baseCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
foreach (Victim item in trueCollection)
{
Debug.WriteLine($"trueCollection id:{item.Id} f_int:{item.FInt} f_bit:{item.FBit}");
}
}
#endif
#if TEST_LIFECYCLE
using (unitOfWorkI = new UnitOfWork())
{
xpCollectionI = new XPCollection(typeof(TestMaster));
AddEventsListeners(xpCollectionI);
if ((tmpTestMaster = ((IBindingList)xpCollectionI).AddNew() as TestMaster) != null)
{
tmpTestMaster.Name = "Name";
tmpTestMaster.Save();
}
foreach (TestMaster item in xpCollectionI)
{
System.Diagnostics.Debug.WriteLine(item.Id);
}
RemoveEventsListeners(xpCollectionI);
}
#endif
#if TEST_ADD
using (unitOfWorkI = new UnitOfWork())
{
xpCollectionI = new XPCollection(unitOfWorkI, typeof(TestDE));
#if TEST_LIFECYCLE
AddEventsListeners(xpCollectionI);
#endif
if ((tmpTestDE = ((IBindingList)xpCollectionI).AddNew() as TestDE) != null)
{
tmpTestDE.f1 = 1;
}
#if TEST_LIFECYCLE
RemoveEventsListeners(xpCollectionI);
#endif
tmpTestMaster = new TestMaster(unitOfWorkI);
#if TEST_LIFECYCLE
AddEventsListeners(tmpTestMaster);
AddEventsListeners(tmpTestMaster.Details);
#endif
if ((tmpTestDetail = ((IBindingList)tmpTestMaster.Details).AddNew() as TestDetail) != null)
{
tmpTestDetail.Name = "blah-blah-blah";
}
#if TEST_LIFECYCLE
RemoveEventsListeners(tmpTestMaster.Details);
RemoveEventsListeners(tmpTestMaster);
#endif
}
#endif
#if TEST_MODIFY
using (unitOfWorkI = new UnitOfWork())
{
xpCollectionI = new XPCollection(unitOfWorkI, typeof(TestDE));
xpCollectionII = new XPCollection(unitOfWorkI, typeof(TestDE));
criteria = new BinaryOperator(new OperandProperty("id"), new OperandValue(1L), BinaryOperatorType.Equal);
xpCollectionI.Filter = criteria;
xpCollectionII.Filter = criteria;
if (xpCollectionI.Count != 0)
{
tmpTestDE = xpCollectionI[0] as TestDE;
}
if (xpCollectionII.Count != 0)
{
tmpTestDEII = xpCollectionI[0] as TestDE;
}
if (tmpTestDE != null)
{
tmpTestDE.f1 = tmpTestDE.f1.HasValue ? tmpTestDE.f1.Value + 1 : 1;
tmpTestDE.Save();
}
if (tmpTestDEII != null)
{
tmpTestDEII.f1 = tmpTestDEII.f1.HasValue ? tmpTestDEII.f1.Value + 1 : 1;
tmpTestDEII.Save();
}
unitOfWorkI.CommitChanges();
}
#endif
#if TEST_LOAD
xpCollectionI = new XPCollection(sessionI, testMasterClassInfo);
xpCollectionI.Load();
xpCollectionI.Reload();
var listOfTestMaster = sessionI.GetObjects(testMasterClassInfo, new BinaryOperator("Name", "TEST An item with the same key has already been added 1:1", BinaryOperatorType.Equal), null, 0, 0, true, true).OfType <TestMaster>().ToList();
if (listOfTestMaster.Count > 0)
{
tmpTestMaster = listOfTestMaster[0];
if (tmpTestMaster.Details.Count > 0)
{
tmpString = tmpTestMaster.Details[0].Val;
}
}
#endif
#if TEST_An_item_with_the_same_key_has_already_been_added
var listOfTestMaster = sessionI.GetObjects(testMasterClassInfo, new BinaryOperator("Name", "TEST An item with the same key has already been added 1:N", BinaryOperatorType.Equal), null, 0, 0, true, true).OfType <TestMaster>().ToList();
if (listOfTestMaster.Count > 0)
{
tmpTestMaster = listOfTestMaster[0];
tmpString = tmpTestMaster.DetailVal;
}
#endif
#if TEST_CREATE
if ((tmpTestMaster = testMasterClassInfo.CreateNewObject(sessionI) as TestMaster) != null)
{
tmpTestMaster.Name = DateTime.Now.Ticks.ToString();
tmpTestMaster.Details.AddRange(new[]
{
testDetailClassInfo.CreateNewObject(sessionI) as TestDetail,
testDetailClassInfo.CreateNewObject(sessionI) as TestDetail,
testDetailClassInfo.CreateNewObject(sessionI) as TestDetail
});
tmpTestMaster.Details.ToList().ForEach(item => item.Name = DateTime.Now.Ticks.ToString());
sessionI.Save(tmpTestMaster);
}
#endif
#if TEST_SET
tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L);
tmpInt = tmpTestMaster.Details.Count;
sessionII = new Session();
tmpTestMasterII = sessionII.GetObjectByKey <TestMaster>(2L);
tmpTestDetailII = sessionII.GetObjectByKey <TestDetail>(2L);
tmpTestDetailII.Master = tmpTestMasterII;
sessionII.Save(tmpTestDetailII);
tmpInt = tmpTestMaster.Details.Count;
#endif
#if TEST_REMOVE
tmpTestMaster = sessionI.GetObjectByKey <TestMaster>(1L);
tmpInt = tmpTestMaster.Details.Count;
sessionII = new Session();
tmpTestMasterII = sessionII.GetObjectByKey <TestMaster>(1L);
tmpTestDetailII = sessionII.GetObjectByKey <TestDetail>(2L);
tmpTestMasterII.Details.Remove(tmpTestDetailII);
sessionII.Save(new XPCustomObject[] { tmpTestMasterII, tmpTestDetailII });
tmpInt = tmpTestMaster.Details.Count;
#endif
}