/// <summary> /// Executes a Query SQL Statement in an Embedded Resource. An exception will be thrown if the connection is not open. /// </summary> /// <param name="connection">IDbConnection</param> /// <param name="embeddedResource">Embedded Resource Name</param> /// <param name="assembly">Assembly Where Embedded Resource Resides</param> /// <param name="commandCallback">Parameter lambda expression callback in the form (command) => { }</param> /// <param name="readerCallback">Reader lambda expression callback in the form (reader) => { }</param> /// <param name="validateParameters">If set to <c>true</c> validate parameters.</param> public static void ExecuteQueryEmbeddedResource(this IDbConnection connection, string embeddedResource, System.Reflection.Assembly assembly, Action <IDbCommand> commandCallback, Action <IDataReader> readerCallback, bool validateParameters = false) { if (embeddedResource == null) { throw new ArgumentNullException(nameof(embeddedResource)); } string sql = assembly.GetEmbeddedResourceString(embeddedResource); connection.ExecuteQueryString(sql, commandCallback, readerCallback, validateParameters); }
/// <summary> /// Creates a new IDbCommand with an initialized from a specifed embedded resource. /// </summary> /// <returns>The with embedded resource.</returns> /// <param name="connection">IDbConnection</param> /// <param name="embeddedResource">Embedded resource name</param> /// <param name="assembly">Assembly where embedded resource exists</param> public static IDbCommand CommandWithEmbeddedResource(this IDbConnection connection, string embeddedResource, System.Reflection.Assembly assembly) { if (embeddedResource == null) { throw new ArgumentNullException(nameof(embeddedResource)); } if (assembly == null) { throw new ArgumentNullException(nameof(assembly)); } string sql = assembly.GetEmbeddedResourceString(embeddedResource); return(connection.CommandWithSqlString(sql)); }
/// <summary> /// Executes a Query SQL statement, returning a scalar value. An exception will be thrown if the connection is not open. /// </summary> /// <param name="connection">IDbConnection</param> /// <param name="embeddedResource">Embedded Resource Name</param> /// <param name="assembly">Assembly Where Embedded Resource Resides</param> /// <param name="commandCallback">Parameter lambda expression callback in the form (command) => { }</param> /// <param name="validateParameters">If set to <c>true</c> validate parameters.</param> /// <returns>Scalar value</returns> public static object ExecuteScalarEmbeddedResource(this IDbConnection connection, string embeddedResource, System.Reflection.Assembly assembly, Action <IDbCommand> commandCallback = null, bool validateParameters = false) { if (embeddedResource == null) { throw new ArgumentNullException(nameof(embeddedResource)); } if (assembly == null) { throw new ArgumentNullException(nameof(assembly)); } string sql = assembly.GetEmbeddedResourceString(embeddedResource); return(connection.ExecuteQueryScalar(sql, commandCallback, validateParameters)); }
/// <summary> /// Executes a Non Query SQL Statement from an embedded resource for a DbField decorated object. Sql Parameters will be automatically populated. /// An exception will be thrown if the connection is not open. /// </summary> /// <param name="connection">IDbConnection</param> /// <param name="embeddedResource">Embedded Resource Name</param> /// <param name="assembly">Assembly Where Embedded Resource Resides</param> /// <param name="obj">Model object from which parameters are to be populated</param> /// <param name="validateParameters">If set to <c>true</c> validate parameters.</param> /// <returns>Number of records affected</returns> /// <typeparam name="T">Data Type</typeparam> public static int ExecuteNonQueryEmbeddedResourceForObject <T>(this IDbConnection connection, string embeddedResource, System.Reflection.Assembly assembly, T obj, bool validateParameters = false) where T : class { if (embeddedResource == null) { throw new ArgumentNullException(nameof(embeddedResource)); } if (obj == null) { throw new ArgumentNullException(nameof(obj)); } if (assembly == null) { throw new ArgumentNullException(nameof(assembly)); } string sql = assembly.GetEmbeddedResourceString(embeddedResource); return(connection.ExecuteNonQueryStringForObject(sql, obj, validateParameters)); }
/// <summary> /// Executes a Query SQL Statement in an Embedded Resource. An exception will be thrown if the connection is not open. /// </summary> /// <param name="connection">IDbConnection</param> /// <param name="embeddedResource">Embedded Resource Name</param> /// <param name="assembly">Assembly Where Embedded Resource Resides</param> /// <param name="readerCallback">Reader lambda expression callback in the form (reader) => { }</param> /// <param name="validateParameters">If set to <c>true</c> validate parameters.</param> public static void ExecuteQueryEmbeddedResource(this IDbConnection connection, string embeddedResource, System.Reflection.Assembly assembly, Action <IDataReader> readerCallback, bool validateParameters = false) { string sql = assembly.GetEmbeddedResourceString(embeddedResource); connection.ExecuteQueryString(sql, null, readerCallback, validateParameters); }