public void Initialize() { using (var connection = new SqlConnection(ConnectionString)) { connection.Open(); var server = new Server(new ServerConnection(connection)); // get the database const string databaseName = "TransactionScopeTests"; Database transactionScopeTests = server.Databases[databaseName]; if (null != transactionScopeTests) { server.KillDatabase(databaseName); } transactionScopeTests = new Database(server, databaseName); transactionScopeTests.Create(false); using (SqlCommand sqlCommand = connection.CreateCommand()) { // ReSharper disable once AssignNullToNotNullAttribute sqlCommand.CommandText = Resources.CreateTables; sqlCommand.ExecuteNonQuery(); } } }
public void PolymorphicEnumeration() { var stgs = new IStorage[] { new MemoryStorage(), //new PersistedMemoryStorage(), new FileSystemStorage("fs"), //new EsentStorage("esent"), new SqlSeverStorage("server=.;database=overdb;integrated security=true"), }; foreach (var stg in stgs) { using (var db = new Database(stg, null, new GuidIdFactory())) { db.Delete(db.GetEnumerable()); db.SaveMany(new Animal[] { new Cat(), new Dog(), new Cow(), }.AsEnumerable()); var animals = db.GetEnumerable<Animal>(); Assert.That(animals.Count(), Is.EqualTo(3), "{0} not polymorphic", stg.GetType().Name); } } }
public void SetupSchema() { using (var db = new Database("database")) { db.Execute(sql); } }
static void Main() { DapperExtensions.DapperExtensions.SqlDialect = new SqliteDialect(); var database = new Database(); database.Create(); database.Insert(); database.SelectAll(); database.Select(); database.Paged(); }
public void PolyQueries() { var stgs = new IStorage[] { new MemoryStorage(), //new PersistedMemoryStorage(), new FileSystemStorage("fs"), //new EsentStorage("esent"), new SqlSeverStorage("server=.;database=overdb;integrated security=true"), }; foreach (var stg in stgs) { var idx = new Index<Animal, string>(a => a.Sound, keyComparer: StringComparer.OrdinalIgnoreCase); using (var db = new Database(stg, indexes: new[] { idx }, idFactory: new GuidIdFactory())) { db.Delete(db.GetEnumerable()); db.SaveMany(new Animal[] { new Cat(), new Dog(), new Cow(), }.AsEnumerable()); var animals = db.Query(idx); Assert.That(animals.Count(), Is.EqualTo(3), "{0} not polymorphic", stg.GetType().Name); } } }