public void EmptyProductTest() { var dialect = new Dialect.SQLiteDialect(); var command = Substitute.For<IDbCommand>(); dialect.ConfigureCommand(command, new SqlQuery<Product>()); Assert.AreEqual(command.CommandText, "SELECT [Sku], [Description] FROM [Product]"); }
public void EmptyOrderDetailTest() { var dialect = new Dialect.SQLiteDialect(); var command = Substitute.For<IDbCommand>(); dialect.ConfigureCommand(command, new SqlQuery<OrderDetail>()); Assert.AreEqual(command.CommandText, "SELECT [Id], [OrderId], [Sku], [Quantity], [Price] FROM [OrderDetail]"); }
public void EmptyOrderTest() { var dialect = new Dialect.SQLiteDialect(); var command = Substitute.For<IDbCommand>(); dialect.ConfigureCommand(command, new SqlQuery<Order>()); Assert.AreEqual(command.CommandText, "SELECT [Id], [CreatedDate], [CustomerName] FROM [Order]"); }
public void SimpleSelectAllQuery() { using(var connection = new SQLiteConnection("Data Source=testdb.db;Version=3;Read Only=True;")) { connection.Open(); var dialect = new Dialect.SQLiteDialect(); var runner = new QueryRunner(connection, dialect); var query = new SqlQuery<Order>(); var results = runner.ExecuteReader(query).ToList(); Assert.AreEqual(10, results.Count); results.Select(order => order.Id).AssertSeqeuenceEquals(1, 2, 3, 4, 5, 6, 7, 8, 9, 10); } }