public void UpdateTest() { using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite)) using (var dbcontext = new AdbContext()) { var gr = new GenericUpdater <Surveys, DateTime?>(sourceContext: dbcontext, destinationContext: dbOffcontext); var max = gr.GetMax(a => a.ModifiedOn); var c = gr.GetToUpdateData(a => a.ModifiedOn, b => b.ModifiedOn != null && b.ModifiedOn > max, false); } }
public void GenericMaxTest() { using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite)) using (var dbcontext = new AdbContext()) { var gr = new GenericUpdater <Surveys, DateTime?>(dbcontext, dbOffcontext); var b = gr.GetMax(a => a.ModifiedOn); Assert.AreEqual(1, 1); } }
public void InsertTest() { using (var dbOffcontext = new AdbContext(DatabaseType.Sqlite)) using (var dbcontext = new AdbContext()) { var gr = new GenericUpdater <Surveys, DateTime?>(sourceContext: dbcontext, destinationContext: dbOffcontext); var max = gr.GetMax(a => a.CreatedOn); var c = gr.GetToUpdateData(a => a.CreatedOn, b => b.CreatedOn != null && b.CreatedOn > max, true); Assert.AreEqual(c, 1); } }
public void GenericSelectTest() { using (var dbcontext = new AdbContext()) { var gr = new GenericRepository <Rule>(dbcontext); Rule r = new Rule { RuleId = 1, Name = "New", Description = "inserted" }; gr.Insert(r); gr.Save(); var updater = new Rule { RuleId = 9, Name = "updated", Description = "Updated" }; gr.Update(updater); gr.Save(); var f = gr.Get(a => a.Name == "New", d => d.OrderBy(s => s.Name), ""); Assert.AreEqual(1, 1); } }
public void Test() { using (var dbcontext = new AdbContext()) { var gr = new GenericRepository <Rule>(dbcontext); var m = new Rule(); m.RuleId = 1; m.Description = "a"; m.Name = "a"; var n = new Rule(); n.RuleId = 1; n.Description = "b"; n.Name = "b"; gr.InsertOrUpdate(n, a => a.RuleId == n.RuleId); gr.InsertOrUpdate(m, a => a.RuleId == m.RuleId); gr.Save(); } }
public void TestSyncInserts() { using (var dbOffLinecontext = new AdbContext(DatabaseType.Sqlite)) { var maxcreatedon = dbOffLinecontext.Surveys.Max(s => s.CreatedOn); maxcreatedon = maxcreatedon ?? DateTime.Now.AddYears(-20); List <Surveys> newSurveys; using (var dbOnLinecontext = new AdbContext()) { var surveys = from s in dbOnLinecontext.Surveys where s.CreatedOn != null && s.CreatedOn > maxcreatedon select s; var a = surveys.ToList(); newSurveys = a; } if (newSurveys.Count > 0) { dbOffLinecontext.Surveys.AddRange(newSurveys); dbOffLinecontext.SaveChanges(); } } }
public void TestSyncUpdates() { using (var dbOffLinecontext = new AdbContext(DatabaseType.Sqlite)) { var maxModifiedDate = dbOffLinecontext.Surveys.Max(s => s.ModifiedOn); List <Surveys> updatedData; using (var dbOnLinecontext = new AdbContext()) { var surveys = from s in dbOnLinecontext.Surveys where s.ModifiedOn != null && s.ModifiedOn > maxModifiedDate select s; updatedData = surveys.ToList(); } foreach (var item in updatedData) { dbOffLinecontext.Surveys.Attach(item); dbOffLinecontext.Entry(item).State = EntityState.Modified; } var i = dbOffLinecontext.SaveChanges(); } }
public void Genericcrudetest() { using (var dbcontext = new AdbContext()) { var gr = new GenericRepository <Rule>(dbcontext); var m = new Rule(); m.RuleId = 10; m.Description = "test"; m.Name = "what"; gr.Insert(m); gr.Save(); var d = gr.Get(s => s.Name == "what"); foreach (var item in d) { gr.Delete(item); } gr.Save(); Assert.AreEqual(1, 1); } }