public static void Main(string[] args) { var persitor = new DatabasePersistor("DataContext", migrationConfig: new MySqlMigrationsConfiguration()); persitor.Insert(new TestDataClass { Value = ".NET Core" }); using (var db = persitor.GetConnection()) { var cnt = db.Insert(new TestDataClass() { Value = "From Dapper" }); Console.WriteLine($"Inserted {cnt}"); var result = db.Query <TestDataClass>("select * from TestDataClass where Id = 1"); if (result.Single().Value == ".NET Core") { Console.WriteLine("Dapper works"); } } Console.WriteLine("Done..."); Console.ReadLine(); }
public void CouldSelectManyDistributedDataObject() { var Persistor = new DatabasePersistor(migrationConfig: new PostgresMigrationsConfiguration(), distributedMigrationConfig: new DistributedPostgresMigrationsConfiguration(), guidType: SequentialGuidType.SequentialAsBinary); var values = Persistor.Select <RootAsset>().Select(ra => ra.Id).ToList(); RootAsset a; foreach (var value in values) { a = Persistor.GetById <RootAsset>(value); } }
public void CouldCreateTableAndInsertManyDistributedDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary); var sw = new Stopwatch(); sw.Start(); var list = new List <RootAsset>(); for (int i = 0; i < 100000; i++) { var dobj = new RootAsset() { Value = "inserted" }; list.Add(dobj); } Persistor.Insert(list); sw.Stop(); Console.WriteLine("Elapsed: " + sw.ElapsedMilliseconds); }
public void CouldCreateTableAndCrudDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary); for (int i = 0; i < 10; i++) { var dobj = new TestDataObject() { Value = "inserted" }; Persistor.Insert(dobj); var fromDb = Persistor.GetById <TestDataObject>(dobj.Id); Assert.AreEqual("inserted", fromDb.Value); fromDb.Value = "updated"; Persistor.Update(fromDb); fromDb = Persistor.GetById <TestDataObject>(dobj.Id); Assert.AreEqual("updated", fromDb.Value); } }
public void CouldCreateTableAndInsertManyDataObject() { var Persistor = new DatabasePersistor(migrationConfig: new PostgresMigrationsConfiguration(), distributedMigrationConfig: new DistributedPostgresMigrationsConfiguration(), guidType: SequentialGuidType.SequentialAsBinary); var sw = new Stopwatch(); sw.Start(); var list = new List <TestDataObject>(); for (int i = 0; i < 1000; i++) { var dobj = new TestDataObject() { Value = "inserted" }; //Persistor.Insert(dobj); list.Add(dobj); } Persistor.Insert(list); sw.Stop(); Console.WriteLine("Elapsed: " + sw.ElapsedMilliseconds); }
public void CouldCreateTableAndCrudDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsString, migrationConfig: new MySqlMigrationsConfiguration()); for (int i = 0; i < 1; i++) { var dobj = new TestDataObject() { Value = "inserted", DateTime = DateTime.UtcNow }; Persistor.Insert(dobj); var fromDb = Persistor.GetById <TestDataObject>(dobj.Id); Assert.AreEqual("inserted", fromDb.Value); fromDb.Value = "updated"; Persistor.Update(fromDb); fromDb = Persistor.GetById <TestDataObject>(dobj.Id); Assert.AreEqual("updated", fromDb.Value); } }
public void CouldSelectManyDistributedDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary); //Persistor.CreateTable<RootAsset>(true); //var list = new List<RootAsset>(); //for (int i = 0; i < 100000; i++) { // var dobj = new RootAsset() { // Value = "inserted" // }; // list.Add(dobj); //} //Persistor.Insert(list); var values = Persistor.Select <RootAsset>().Select(ra => ra.Id).ToList(); RootAsset a; foreach (var value in values) { a = Persistor.GetById <RootAsset>(value); } //Persistor.GetByIds<RootAsset>(values); }
public void CouldInsertDataRecords() { var Persistor = new DatabasePersistor(migrationConfig: new MySqlMigrationsConfiguration(), guidType: SequentialGuidType.SequentialAsBinary); var list = new List <DataRecord>(); for (int i = 0; i < 100000; i++) { var dobj = new DataRecord() { Source = 0, Entity = i * 10, Relationship = i * 10, Metric = i / 100, Period = DateTime.Today, ObservationTime = DateTime.Now, Value = 123 + ((double)i) / 100.0 }; list.Add(dobj); } Persistor.Insert(list); }
public void CouldCreateTableAndCrudDistributedDataObject() { var Persistor = new DatabasePersistor(migrationConfig: new PostgresMigrationsConfiguration(), distributedMigrationConfig: new DistributedPostgresMigrationsConfiguration(), guidType: SequentialGuidType.SequentialAsBinary); for (int i = 0; i < 1; i++) { var dobj = new RootAsset() { Value = "inserted" }; Persistor.Insert(dobj); var fromDb = Persistor.GetById <RootAsset>(dobj.Id); Assert.AreEqual("inserted", fromDb.Value); Console.WriteLine(dobj.Id); fromDb.Value = "updated"; Persistor.Update(fromDb); fromDb = Persistor.GetById <RootAsset>(dobj.Id); Assert.AreEqual("updated", fromDb.Value); } }
public void CouldCreateTableAndInsertManyDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsBinary); var sw = new Stopwatch(); sw.Start(); var list = new List<TestDataObject>(); for (int i = 0; i < 1000; i++) { var dobj = new TestDataObject() { Value = "inserted" }; //Persistor.Insert(dobj); list.Add(dobj); } Persistor.Insert(list); sw.Stop(); Console.WriteLine("Elapsed: " + sw.ElapsedMilliseconds); }
public void CouldCreateTableAndCrudDataObject() { var Persistor = new DatabasePersistor(guidType: SequentialGuidType.SequentialAsString, migrationConfig: new MySqlMigrationsConfiguration()); for (int i = 0; i < 1; i++) { var dobj = new TestDataObject() { Value = "inserted", DateTime = DateTime.UtcNow }; Persistor.Insert(dobj); var fromDb = Persistor.GetById<TestDataObject>(dobj.Id); Assert.AreEqual("inserted", fromDb.Value); fromDb.Value = "updated"; Persistor.Update(fromDb); fromDb = Persistor.GetById<TestDataObject>(dobj.Id); Assert.AreEqual("updated", fromDb.Value); } }
public void CouldInsertDataRecords() { var Persistor = new DatabasePersistor(migrationConfig: new MySqlMigrationsConfiguration(), guidType: SequentialGuidType.SequentialAsBinary); var list = new List<DataRecord>(); for (int i = 0; i < 100000; i++) { var dobj = new DataRecord() { Source = 0, Entity = i*10, Relationship = i*10, Metric = i/100, Period = DateTime.Today, ObservationTime = DateTime.Now, Value = 123 + ((double)i)/100.0 }; list.Add(dobj); } Persistor.Insert(list); }