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