public void CanBulkInsertToPostgresNonGenericly() { var mappings = new Mappings(typeof(Db)).MapAsLowercaseUnderscore(); var bcp = new Chronos.PostgreSQL.PostgresBulkInserter("Server=127.0.0.1;Port=5432;Database=jinx;User Id=postgres;Password=postgres", typeof(Db),mappings); var itemsToInsert = new List<Db> { new Db {DatabaseId = Guid.NewGuid(), Name = "NonGeneric"}, new Db {DatabaseId = Guid.NewGuid(), Name = "RNonGenericandom2"}, new Db {DatabaseId = Guid.NewGuid(), Name = "RNonGenericandom4"}, new Db {DatabaseId = Guid.NewGuid(), Name = "RNonGenericandom3"}, new Db {DatabaseId = Guid.NewGuid(), Name = "NonGenericRandom5"}, new Db {DatabaseId = Guid.NewGuid(), Name = "RNonGenericandom6"}, new Db {DatabaseId = Guid.NewGuid(), Name = "RNonGenericandom7"}, }; bcp.Insert(itemsToInsert, "databases"); }
public void CanBulkInsertIntoPostgres() { var mappings = new Mappings<Db>().MapAsLowercaseUnderscore(); Chronos.PostgreSQL.PostgresBulkInserter<Db> bcp = new Chronos.PostgreSQL.PostgresBulkInserter<Db>("Server=127.0.0.1;Port=5432;Database=jinx;User Id=postgres;Password=postgres", mappings); var itemsToInsert = new List<Db> { new Db {DatabaseId = Guid.NewGuid(), Name = "Random1"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random2"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random4"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random3"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random5"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random6"}, new Db {DatabaseId = Guid.NewGuid(), Name = "Random7"}, }; bcp.Insert(itemsToInsert, "databases"); }