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);
}
}
