/// <summary>
/// Generate SQL query with sql parameters.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="top"></param>
/// <returns></returns>
public static string SelectQueryGenerate <T>(this DatabaseConnectorBase connector, int?top = null)
where T : class
{
var tableName = typeof(T).TableNameAttributeValidate();
var query = $"SELECT {(top.HasValue ? $"TOP({top.Value})" : "")} * FROM {tableName}";
return(query);
}
/// <summary> /// Generate SQL query with sql parameters. /// </summary> /// <typeparam name="T"></typeparam> /// <param name="predicate"></param> /// <param name="top"></param> /// <returns></returns> public static (string query, IEnumerable <DatabaseParameter> parameters) SelectQueryGenerate <T>(this DatabaseConnectorBase connector, Expression <Func <T, bool> > predicate, int?top = null)
