public static void Replicate() { try { var contextCreator = new TransactionContextCreator(@"Data Source = C:\Users\PetarPetrov\Desktop\server.sqlite; Version = 3;"); var clientData = new ClientData(); clientData.Add(new Dictionary <string, FeatureContextRow> { { @"Agenda", new FeatureContextRow(1, @"Agenda") } }); clientData.Add(new[] { new FeatureExceptionRow(1, @"new exception : stack trace => ..."), }); clientData.Add(new Dictionary <long, List <FeatureRow> >() { { 1, new List <FeatureRow>() { new FeatureRow(1, @"Add Activity", 1), new FeatureRow(2, @"Close Activity", 1), new FeatureRow(3, @"Cancel Activity", 1), } }, }); clientData.Add(new[] { new FeatureEntryRow(2, "N/A", DateTime.Now), new FeatureEntryRow(3, "Sick", DateTime.Now) }); clientData.Add(new[] { new FeatureExceptionEntryRow(1, DateTime.Today.AddDays(-1), 1), }); //ResetSchema(contextCreator); var s = Stopwatch.StartNew(); using (var ctx = contextCreator.Create()) { //FeatureServerManager.CreateSchema(ctx); for (var i = 0; i < 1; i++) { FeatureManager.Replicate(ctx, @"BG900343", @"1.0.0.0", clientData.GetBytes()); } ctx.Complete(); } s.Stop(); Console.WriteLine(s.ElapsedMilliseconds); } catch (Exception ex) { Console.WriteLine(ex); } }
public byte[] GetClientDataBytes() { using (var dbContext = this.ContextCreator()) { this.Load(dbContext); var data = new ClientData(); data.Add(this.Contexts); data.Add(FeatureAdapter.GetExceptions(dbContext)); data.Add(this.Features); data.Add(FeatureAdapter.GetFeatureEntries(dbContext)); data.Add(FeatureAdapter.GetExceptionEntries(dbContext)); dbContext.Complete(); return(data.GetBytes()); } }
public ActionResult Create([Bind(Include = "ClientName" + "," + "Address1" + "," + "Address2" + "," + "City" + "," + "District" + "," + "State" + "," + "PinCode" + "," + "ContactNo" + "," + "EMail" + "," + "GSTIN" + "," + "CompanyID" + "," + "AddUserID" + "," + "AddDate" + "," + "ArchiveUserID" + "," + "ArchiveDate" )] Client Client) { if (ModelState.IsValid) { bool bSucess = false; bSucess = ClientData.Add(Client); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Insert"); } } // ComboBox ViewData["CompanyID"] = new SelectList(Client_CompanyData.List(), "CompanyID", "CompanyName", Client.CompanyID); return(View(Client)); }