Example #1
0
        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);
        }
Example #6
0
        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);
        }