public async Task SelectAsyncContains(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = await con.SelectAsync <Product>(p => p.Name.Contains("Chai")); Assert.NotEmpty(products); } }
public void Get(DatabaseDriver database) { using (var con = database.GetConnection()) { var product = con.Get <Product>(1); Assert.NotNull(product); Assert.NotEmpty(product.Name); } }
public void FirstOrDefault_EndsWith(DatabaseDriver database) { var productName = "2"; using var con = database.GetConnection(); var product = con.FirstOrDefault <Product>(p => p.Name !.EndsWith(productName)); Assert.NotNull(product); }
public void OneToOneNotExisting(DatabaseDriver database) { using (var con = database.GetConnection()) { var product = con.Get <Product, Category, Product>(11); Assert.NotNull(product); Assert.Null(product.Category); } }
public async Task FirstOrDefaultAsync_ContainsVariable(DatabaseDriver database) { var productName = "Anton"; using var con = database.GetConnection(); var product = await con.FirstOrDefaultAsync <Product>(p => p.Name !.Contains(productName)); Assert.NotNull(product); }
public async Task ProjectAsync(DatabaseDriver database) { using var con = database.GetConnection(); var p = await con.ProjectAsync <ProductSmall>(1); Assert.NotNull(p); Assert.NotEqual(0, p !.ProductId); Assert.NotNull(p.Name); }
public void OneToManyNonExsting(DatabaseDriver database) { using (var con = database.GetConnection()) { var order = con.Get <Order, OrderLine, Order>(2); Assert.NotNull(order); Assert.Null(order.OrderLines); } }
public void Get_CompositeKey(DatabaseDriver database) { using var con = database.GetConnection(); var product = con.Get <ProductsCategories>(1, 1); Assert.NotNull(product); Assert.Equal(1, product !.ProductId); Assert.Equal(1, product.CategoryId); }
public void Project(DatabaseDriver database) { using var con = database.GetConnection(); var p = con.Project <ProductSmall>(1); Assert.NotNull(p); Assert.NotEqual(0, p !.ProductId); Assert.NotNull(p.Name); }
public async Task SelectAsyncContainsVariable(DatabaseDriver database) { var productName = "Anton"; using var con = database.GetConnection(); var products = await con.SelectAsync <Product>(p => p.Name !.Contains(productName)); Assert.Equal(4, products.Count()); }
public async Task GetAsync_CompositeKey(DatabaseDriver database) { using var con = database.GetConnection(); var product = await con.GetAsync <ProductsCategories>(1, 1); Assert.NotNull(product); Assert.Equal(1, product !.ProductId); Assert.Equal(1, product.CategoryId); }
public async Task SelectAsyncEqual(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = await con.SelectAsync <Product>(p => p.CategoryId == 1); Assert.Equal(10, products.Count()); } }
public async Task SelectAll(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = await con.FromAsync <Product>(sql => sql.Select()); Assert.NotEmpty(products); } }
public async Task SelectAsyncContains(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = await con.SelectAsync <Product>(p => p.Name.Contains("Anton")); Assert.Equal(4, products.Count()); } }
public void GetAll(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = con.GetAll <Product>(); Assert.NotEmpty(products); Assert.All(products, p => Assert.NotEmpty(p.Name)); } }
public async Task SelectAsyncStartsWith(DatabaseDriver database) { var productName = "Cha"; using var con = database.GetConnection(); var products = await con.SelectAsync <Product>(p => p.Name !.StartsWith(productName)); Assert.Equal(4, products.Count()); }
public void Get_OneToMany(DatabaseDriver database) { using var con = database.GetConnection(); var order = con.Get <Order, OrderLine, Order>(1); Assert.NotNull(order); Assert.NotNull(order.OrderLines); Assert.Equal(3, order.OrderLines?.Count); }
public async Task FirstOrDefaultAsync_StartsWith(DatabaseDriver database) { var productName = "Cha"; using var con = database.GetConnection(); var product = await con.FirstOrDefaultAsync <Product>(p => p.Name !.StartsWith(productName)); Assert.NotNull(product); }
public void Select_ContainsVariable_CaseInsensitive(DatabaseDriver database) { var productName = "anton"; using var con = database.GetConnection(); var products = con.Select <Product>(p => p.Name !.Contains(productName)); Assert.Equal(4, products.Count()); }
public void Select_EndsWith(DatabaseDriver database) { var productName = "2"; using var con = database.GetConnection(); var products = con.Select <Product>(p => p.Name !.EndsWith(productName)); Assert.Equal(5, products.Count()); }
public void Select_StartsWith_CaseInsensitive(DatabaseDriver database) { var productName = "cha"; using var con = database.GetConnection(); var products = con.Select <Product>(p => p.Name !.StartsWith(productName)); Assert.Equal(4, products.Count()); }
public async Task GetAsync_OneToMany(DatabaseDriver database) { using var con = database.GetConnection(); var order = await con.GetAsync <Order, OrderLine, Order>(1); Assert.NotNull(order); Assert.NotNull(order.OrderLines); Assert.Equal(3, order.OrderLines?.Count); }
public void SelectProjectSync(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = con.From <Product>(sql => sql.Select(p => new { p.ProductId, p.Name })); Assert.NotEmpty(products); Assert.All(products, p => Assert.Equal(0, p.CategoryId)); } }
public async Task GetAllAsync(DatabaseDriver database) { using (var con = database.GetConnection()) { var products = await con.GetAllAsync <Product>(); Assert.NotEmpty(products); Assert.All(products, p => Assert.NotEmpty(p.Name)); } }
public async Task GetAsync_OneToManyNonExsting(DatabaseDriver database) { using (var con = database.GetConnection()) { var order = await con.GetAsync <Order, OrderLine, Order>(2); Assert.NotNull(order); Assert.Null(order.OrderLines); } }
public async Task GetAsync_OneToOne(DatabaseDriver database) { using var con = database.GetConnection(); var product = await con.GetAsync <Product, Category, Product>(1); Assert.NotNull(product); Assert.NotNull(product.Category); Assert.Equal("Food", product.Category?.Name); Assert.Equal(product.CategoryId, product.Category?.CategoryId); }
public async Task Select_Where(DatabaseDriver database) { using var con = database.GetConnection(); var products = await con.FromAsync <Product>( sql => sql.Select(p => new { p.Name, p.CategoryId }) .Where(p => p.Name !.StartsWith("Chai"))); Assert.NotEmpty(products); Assert.All(products, p => Assert.StartsWith("Chai", p.Name)); }
public void Get_OneToOne(DatabaseDriver database) { using var con = database.GetConnection(); var product = con.Get <Product, Category, Product>(1); Assert.NotNull(product); Assert.NotNull(product.Category); Assert.Equal("Food", product.Category?.Name); Assert.Equal(product.CategoryId, product.Category?.CategoryId); }
public async Task GetAsync_OneToOneNotExisting(DatabaseDriver database) { using (var con = database.GetConnection()) { var product = await con.GetAsync <Product, Category, Product>(11); Assert.NotNull(product); Assert.Null(product.Category); } }
public async Task GetAsync(DatabaseDriver database) { using (var con = database.GetConnection()) { var product = await con.GetAsync <Product>(1); Assert.NotNull(product); Assert.NotEmpty(product.Name); } }