/// <summary>
/// Apply paging from query options
/// </summary>
/// <param name="querable"></param>
/// <param name="queryOptions"></param>
/// <returns></returns>
public static SQLinq.SQLinq <TEntity> ApplyQueryOptions <TEntity>(this SQLinq.SQLinq <TEntity> querable, QueryOptions queryOptions = null)
{
if (querable == null || queryOptions == null)
{
return(querable);
}
querable = querable.Skip(queryOptions.PageSize * (queryOptions.Page - 1))
.Take(queryOptions.PageSize);
return(querable);
}
public void Test1()
{
var arr = new[] { 1, 2, 3, 4, 5, 6 };
var result = new SQLinq.SQLinq <TestClass>(new MySqlDialect())
.Where(x => arr.Contains(x.Id));
var sql = result.ToSQL();
sql.ToQuery();
Assert.Equal("SELECT * FROM `TestClass` WHERE `Id` IN @sqlinq_1", sql.ToQuery());
Assert.NotEmpty(sql.Parameters);
Assert.Equal(sql.Parameters["@sqlinq_1"], arr);
}
public Task <string> GetAppScretAsync(long appId)
{
var t = new SQLinq.SQLinq <ApplicationEntity>().Where(x => x.Id == appId).Select(x => x.AppScret);
return(this._appRepository.GetAppSecuret(appId));
}
