internal static List <T> Execute(string tableName) { StringBuilder query = new StringBuilder(); query.Append($"SELECT * FROM {tableName}"); return(SqlCommandExecuteQueryForSelect <T> .Execute(query.ToString())); }
internal static List <T> Execute(string tableName, string columnAndValueFilter) { StringBuilder query = new StringBuilder(); query.Append($"SELECT * FROM {tableName} "); query.Append($"WHERE {columnAndValueFilter}"); return(SqlCommandExecuteQueryForSelect <T> .Execute(query.ToString())); }
internal static List <T> Execute(string tableName, string pageNumber, string totalPageNumber) { StringBuilder query = new StringBuilder(); query.Append($"SELECT * FROM {tableName} "); query.Append($"ORDER BY(SELECT NULL) "); query.Append($"OFFSET {pageNumber} * {totalPageNumber} ROWS "); query.Append($"FETCH NEXT {totalPageNumber} ROWS ONLY;"); return(SqlCommandExecuteQueryForSelect <T> .Execute(query.ToString())); }
internal static List <T> Execute(string tableName, string pageNumber, string totalPageNumber, string sorting, string columnAndValueFilterLike) { StringBuilder query = new StringBuilder(); query.Append($"SELECT * FROM {tableName} "); query.Append($"WHERE {columnAndValueFilterLike} "); query.Append($"ORDER BY {sorting} "); query.Append($"OFFSET {pageNumber} * {totalPageNumber} ROWS "); query.Append($"FETCH NEXT {totalPageNumber} ROWS ONLY;"); return(SqlCommandExecuteQueryForSelect <T> .Execute(query.ToString())); }