BlogEngine.Core.Providers.DbConnectionHelper.CreateParameter C# (CSharp) Method

CreateParameter() public method

Uses this ConnectionHelper's Provider to create a DbParameter instance with the given parameter name and value.
public CreateParameter ( string parameterName, object value ) : DbParameter
parameterName string The name of the parameter.
value object The value of the parameter.
return System.Data.Common.DbParameter
        public DbParameter CreateParameter(string parameterName, object value)
        {
            return CreateParameter(parameterName, value, null, null);
        }

Same methods

DbConnectionHelper::CreateParameter ( string parameterName, object value, DbType dbType ) : DbParameter
DbConnectionHelper::CreateParameter ( string parameterName, object value, DbType dbType, int size ) : DbParameter

Usage Example

 /// <summary>
 /// Adds blog parameters to command.
 /// </summary>
 /// <param name="blog">
 /// The blog.
 /// </param>
 /// <param name="conn">
 /// The connection.
 /// </param>
 /// <param name="cmd">
 /// The command.
 /// </param>
 private void AddBlogParametersToCommand(
     Blog blog, DbConnectionHelper conn, DbCommand cmd)
 {
     var parms = cmd.Parameters;
     parms.Add(conn.CreateParameter(FormatParamName("BlogId"), blog.Id.ToString()));
     parms.Add(conn.CreateParameter(FormatParamName("BlogName"), blog.Name ?? string.Empty));
     parms.Add(conn.CreateParameter(FormatParamName("Hostname"), blog.Hostname ?? string.Empty));
     parms.Add(conn.CreateParameter(FormatParamName("IsAnyTextBeforeHostnameAccepted"), blog.IsAnyTextBeforeHostnameAccepted));
     parms.Add(conn.CreateParameter(FormatParamName("StorageContainerName"), blog.StorageContainerName));
     parms.Add(conn.CreateParameter(FormatParamName("VirtualPath"), blog.VirtualPath ?? string.Empty));
     parms.Add(conn.CreateParameter(FormatParamName("IsPrimary"), blog.IsPrimary));
     parms.Add(conn.CreateParameter(FormatParamName("IsActive"), blog.IsActive));
     parms.Add(conn.CreateParameter(FormatParamName("IsSiteAggregation"), blog.IsSiteAggregation));
 }
All Usage Examples Of BlogEngine.Core.Providers.DbConnectionHelper::CreateParameter