public void SelectAllProductsDto()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var query = new SQLinq<ProductDto>();
Assert.AreEqual(3, dbConnection.Query(query).Count());
}
}
public void SelectWithEndsWith()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var query = new SQLinq<ProductDto>()
.Where(x => x.Name.EndsWith(ThirdProductName));
Assert.AreEqual(1, dbConnection.Query(query).Count());
}
}
public void UseWithSQLinqSubQuery_001()
{
var query = new SQLinq<MyTable>();
var result = query.ToSQL();
var actual = result.ToQuery();
var expected = "SELECT [Identifier] AS [ID], [FullName] AS [Name] FROM (SELECT [Identifier], [FullName] FROM [tblSomeTable]) AS [MyTable]";
Assert.AreEqual(expected, actual);
}
public void UseWithSQLinqSubQuery_Oracle_001()
{
var dialect = new OracleDialect();
var query = new SQLinq<MyTable>(dialect);
var result = query.ToSQL();
var actual = result.ToQuery();
var expected = "SELECT Identifier AS ID, FullName AS Name FROM (SELECT [Identifier], [FullName] FROM [tblSomeTable]) AS MyTable";
Assert.AreEqual(expected, actual);
}
public void SelectProductDtoById()
{
using (IDbConnection dbConnection = new SqliteConnectionFactory().Create())
{
var query = new SQLinq<ProductDto>()
.Where(x => x.Product_Id == 1);
var firstProduct = dbConnection.Query(query).First();
Assert.AreEqual(FirstProductName, firstProduct.Name);
}
}
public async Task <ApplicationEntity> GetAppInfoEntityAsync(long id)
{
var app = await base.QueryFirstAsync(x => x.Id == id);
var sqlGenerator = new SQLinq <UserEntity>(base.SqlDialect);
sqlGenerator.Where(x => x.Id == app.AppUserId);
var sqlResult = sqlGenerator.ToSQL();
var sql = sqlResult.ToQuery();
var userEntity = await this.Connection.QueryFirstAsync <UserEntity>(sql, sqlResult.Parameters);
app.Account = userEntity;
return(app);
}
public IEnumerable <T> QueryItems <T>(Expression <Func <T, bool> > predicate)
where T : class, new()
{
try
{
SQLinq <T> query = new SQLinq <T>().Where(predicate);
using (IDbConnection dbConnection = new SqlConnection(this.ConnectionString))
{
dbConnection.Open();
return(dbConnection.Query <T>(query));
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SQLinqTable_NameOverride_004()
{
var query = new SQLinq<SQLinqTable_NameOverride_004_Class>("[DatabaseName].[NewTableName]");
var result = (SQLinqSelectResult)query.ToSQL();
Assert.AreEqual("[DatabaseName].[NewTableName]", result.Table);
}
public void SQLinqTable_003()
{
var query = new SQLinq<SQLinqTable_003_Class>();
var result = (SQLinqSelectResult)query.ToSQL();
Assert.AreEqual("[DatabaseName].[TableName]", result.Table);
}
