/// <summary> /// Execute any non-DML SQL Query /// </summary> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns></returns> /// <exception cref="Exception"/> public static int ExecuteNonQuery(string connectionString, string sql, IEnumerable <MySqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(StaticDatabseConnector.ExecuteNonQuery <MySql.Data.MySqlClient.MySqlConnection>(connectionString, sql, parameters, commandType)); }
/// <summary> /// Execute SELECT SQL query and return IEnumerable of specified POCO that is matching with the query columns /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="objectBuilder">How the POCO should build with each giving row of SqlDataReader</param> /// <param name="commandType">Type of SQL Command</param> /// <returns>IEnumerable of POCO</returns> /// <exception cref="Exception"/> public static IEnumerable <T> ExecuteReader <T>(string connectionString, string sql, IEnumerable <MySqlParameter> parameters, Func <DbDataReader, T> objectBuilder, System.Data.CommandType commandType = System.Data.CommandType.Text) where T : new() { return(StaticDatabseConnector.ExecuteReader <T, MySql.Data.MySqlClient.MySqlConnection>(connectionString, sql, parameters, objectBuilder, commandType)); }
/// <summary> /// Execute SELECT SQL query and return IEnumerable of specified POCO that is matching with the query columns /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns>IEnumerable of POCO</returns> /// <exception cref="Exception"/> public static IEnumerable <T> ExecuteReader <T>(string connectionString, string sql, IEnumerable <MySqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) where T : new() { return(StaticDatabseConnector.ExecuteReader <T, MySql.Data.MySqlClient.MySqlConnection>(connectionString, sql, parameters, (cursor) => Data.RowBuilder <T>(cursor), commandType)); }
public static T Select <T>(string connectionString, object primaryKey) where T : class, new() { return(StaticDatabseConnector.Select <T, MySqlConnection, MySqlParameter>(connectionString, primaryKey)); }
public static int Delete <T>(string connectionString, T obj) where T : class, new() { return(StaticDatabseConnector.Delete <T, MySqlConnection, MySqlParameter>(connectionString, obj)); }
/// <summary> /// Execute SELECT SQL query and return a scalar object /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns></returns> /// <exception cref="Exception"/> public static async Task <T> ExecuteScalarAsync <T>(string connectionString, string sql, IEnumerable <MySqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(await StaticDatabseConnector.ExecuteScalarAsync <T, MySql.Data.MySqlClient.MySqlConnection>(connectionString, sql, parameters, commandType)); }
public static IEnumerable <T> Select <T>(string connectionString) where T : class, new() { return(StaticDatabseConnector.Select <T, MySqlConnection>(connectionString)); }
/// <summary> /// Execute SELECT SQL query and return IEnumerable of dynamic object /// </summary> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns>IEnumerable of dynamic object</returns> /// <exception cref="Exception"/> public static IEnumerable <dynamic> ExecuteReader(string connectionString, string sql, IEnumerable <SqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(StaticDatabseConnector.ExecuteReader <SqlConnection>(connectionString, sql, parameters, commandType)); }
/// <summary> /// Execute SELECT SQL query and return a scalar object /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns></returns> /// <exception cref="Exception"/> public static T ExecuteScalar <T>(string connectionString, string sql, IEnumerable <SqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(StaticDatabseConnector.ExecuteScalar <T, SqlConnection>(connectionString, sql, parameters, commandType)); }
public static int Insert <T>(string connectionString, T obj) where T : class, new() { return(StaticDatabseConnector.Insert <T, SqlConnection, SqlParameter>(connectionString, obj)); }
/// <summary> /// Execute any non-DML SQL Query /// </summary> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns></returns> /// <exception cref="Exception"/> public static async Task <int> ExecuteNonQueryAsync(string connectionString, string sql, IEnumerable <SqlParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(await StaticDatabseConnector.ExecuteNonQueryAsync <SqlConnection>(connectionString, sql, parameters, commandType)); }
/// <summary> /// Execute SELECT SQL query and return IEnumerable of specified POCO that is matching with the query columns /// </summary> /// <typeparam name="T"></typeparam> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="objectBuilder">How the POCO should build with each giving row of SqlDataReader</param> /// <param name="commandType">Type of SQL Command</param> /// <returns>IEnumerable of POCO</returns> /// <exception cref="Exception"/> public static async Task <IEnumerable <T> > ExecuteReaderAsync <T>(string connectionString, string sql, IEnumerable <SqlParameter> parameters, Func <DbDataReader, T> objectBuilder, System.Data.CommandType commandType = System.Data.CommandType.Text) where T : new() { return(await StaticDatabseConnector.ExecuteReaderAsync <T, SqlConnection>(connectionString, sql, parameters, objectBuilder, commandType)); }
public static int Update <T>(string connectionString, T obj) where T : class, new() { return(StaticDatabseConnector.Update <T, OracleConnection, OracleParameter>(connectionString, obj)); }
/// <summary> /// Execute SELECT SQL query and return IEnumerable of dynamic object /// </summary> /// <param name="connectionString">Connection string to database</param> /// <param name="sql">Any SELECT SQL that you want to perform with/without parameterized parameters (Do not directly put sql parameter in this parameter)</param> /// <param name="parameters">SQL parameters according to the sql parameter</param> /// <param name="commandType">Type of SQL Command</param> /// <returns>IEnumerable of dynamic object</returns> /// <exception cref="Exception"/> public static async Task <IEnumerable <dynamic> > ExecuteReaderAsync(string connectionString, string sql, IEnumerable <OracleParameter> parameters = null, System.Data.CommandType commandType = System.Data.CommandType.Text) { return(await StaticDatabseConnector.ExecuteReaderAsync <OracleConnection>(connectionString, sql, parameters, commandType)); }