public static void UpdateShouldOnlyUpdateOne() { SqlClientRegistrar.Register <DaoReferenceObject>(); string first = "".RandomString(8); string second = "".RandomString(4); DaoReferenceObject test = new DaoReferenceObject(); test.BoolProperty = true; test.StringProperty = first; Expect.IsTrue(test.IsNew); test.Commit(); DaoReferenceObject one = DaoReferenceObject.OneWhere(f => f.StringProperty == test.StringProperty); one.StringProperty = second; Expect.IsFalse(one.IsNew); one.Commit(); DaoReferenceObjectCollection results = new DaoReferenceObjectCollection( Select <DaoReferenceObjectColumns> .From <DaoReferenceObject>() .Where(f => f.StringProperty == second)); Expect.IsTrue(results.Count == 1); }
public static void QuerySetShouldFillIHasDataTableList() { SqlClientRegistrar.Register <DaoReferenceObject>(); QuerySet testQuerySet = new QuerySet(); Expect.IsNull(testQuerySet.DataSet); DaoReferenceObject test = new DaoReferenceObject(); test.StringProperty = "".RandomString(8); test.Commit(); testQuerySet.Select <DaoReferenceObjectColumns, DaoReferenceObject>(f => f.Id == test.Id); DaoReferenceObject dao = new DaoReferenceObject(); dao.StringProperty = "".RandomString(5); testQuerySet.Insert <DaoReferenceObject>(dao); testQuerySet.Execute(Db.For <DaoReferenceObject>()); Expect.IsNotNull(testQuerySet.DataSet); Expect.IsTrue(testQuerySet.DataSet.Tables.Count == 2); Expect.IsGreaterThan(testQuerySet.Results.Count, 0); Expect.AreEqual(2, testQuerySet.Results.Count); DaoReferenceObject d = testQuerySet.Results.ToDao <DaoReferenceObject>(1); Expect.AreEqual(dao.StringProperty, d.StringProperty); DaoReferenceObjectCollection coll = testQuerySet.Results.As <DaoReferenceObjectCollection>(0); Expect.IsNotNull(coll); Expect.IsGreaterThan(coll.Count, 0); }
public static void QuerySetWhereShouldWorkAsExpected() { SqlClientRegistrar.Register <DaoReferenceObject>(); DaoReferenceObject test = Create(); DaoReferenceObject test2 = Create(); QuerySet query = new QuerySet(); DaoReferenceObject third = new DaoReferenceObject(); third.StringProperty = test.StringProperty; query.Insert(third); query.Select <DaoReferenceObject>().Where <DaoReferenceObjectColumns>(c => c.StringProperty == third.StringProperty); query.Execute(Db.For <DaoReferenceObject>()); DaoReferenceObjectCollection coll = query.Results.As <DaoReferenceObjectCollection>(1); foreach (DaoReferenceObject obj in coll) { Out(obj.PropertiesToString()); Out(); } }
public static void WhereShortCutShouldWork() { SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider); DaoReferenceObject test = new DaoReferenceObject(); test.StringProperty = "".RandomString(8); test.Commit(); DaoReferenceObjectCollection checking = DaoReferenceObject.Where(c => c.StringProperty == test.StringProperty); Expect.IsTrue(checking.Count == 1); }
public static void ShortcutShouldWorkLikeLongcut() { SqlClientRegistrar.Register(Db.For <DaoReferenceObject>().ServiceProvider); DaoReferenceObject test = new DaoReferenceObject(); string val = "".RandomString(8); test.StringProperty = val; test.Commit(); DaoReferenceObjectCollection results = DaoReferenceObject.Where(f => f.Id == test.Id); Expect.IsTrue(results.Count > 0); Expect.IsTrue(results[0].StringProperty.Equals(val)); }
public ActionResult Save(Bam.Net.DaoRef.DaoReferenceObject[] values) { try { DaoReferenceObjectCollection saver = new DaoReferenceObjectCollection(); saver.AddRange(values); saver.Save(); return(Json(new { Success = true, Message = "", Dao = "" })); } catch (Exception ex) { return(GetErrorResult(ex)); } }