System.Data.Common.DbProviderFactory.CreateParameter()

Here are the examples of the csharp api class System.Data.Common.DbProviderFactory.CreateParameter() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

27 Examples 7

1. Example

View license
public override DbParameter CreateParameter()
        {
            return _dbProviderFactory.CreateParameter();
        }

2. Example

Project: Glimpse
Source File: GlimpseDbProviderFactory.cs
View license
public override DbParameter CreateParameter()
        {
            return InnerFactory.CreateParameter();
        }

3. Example

Project: LCLFramework
Source File: LIDbAccesser.cs
View license
public DbParameter CreateDbParameter(string name, ParameterDirection parameterDirection, object value)
        {
            DbParameter parameter = providerFactory.CreateParameter();
            parameter.ParameterName = name;
            parameter.Value = value;
            parameter.Direction = parameterDirection;
            return parameter;
        }

4. Example

View license
public override DbParameter CreateParameter()
        {
            return tail.CreateParameter();
        }

5. Example

Project: Susanoo
Source File: DatabaseManager.cs
View license
public virtual DbParameter CreateParameter(string parameterName, ParameterDirection parameterDirection,
            DbType parameterType, object value)
        {
            var newParam = Provider.CreateParameter();
            if (newParam != null)
            {
                newParam.ParameterName = parameterName;
                newParam.Direction = parameterDirection;
                newParam.DbType = parameterType;
                newParam.Value = value;
            }
            return newParam;
        }

6. Example

View license
public override IDbDataParameter GetParameterCursor() {
            IDbDataParameter parameter = DbProviderFactory.CreateParameter();
            ReflectionCache.PropParameterDbType.SetValue(parameter, ReflectionCache.DbTypeRefCursor, null);
            return parameter;
        }

7. Example

Project: sharpmigrations
Source File: DataProvider.cs
View license
public IDbDataParameter GetParameter() {
            return DbProviderFactory.CreateParameter();
        }

8. Example

Project: sharpmigrations
Source File: DataProvider.cs
View license
public virtual IDbDataParameter GetParameterCursor() {
            return DbProviderFactory.CreateParameter();
        }

9. Example

View license
public static DbParameter CreateParameter(this Database database)
        {
            return database.DbProviderFactory.CreateParameter();
        }

10. Example

Project: Goo-Micro-ORM
Source File: DBManager.cs
View license
public void AddParameter<T>(string name, T value)
        {
            if (command != null)
            {
                var parameter = provider.Value.CreateParameter();
                parameter.ParameterName = name;
                parameter.Value = value;

                command.Parameters.Add(parameter);
            }
            else
                throw new Exception("DbCommand object can not be null.");
        }

11. Example

Project: Dos.ORM
Source File: Database.cs
View license
private DbParameter CreateParameter(string name)
        {
            DbParameter param = dbProvider.DbProviderFactory.CreateParameter();
            param.ParameterName = dbProvider.BuildParameterName(name);

            return param;
        }

12. Example

Project: Dos.ORM
Source File: Database.cs
View license
private DbParameter CreateParameter(string name)
        {
            DbParameter param = dbProvider.DbProviderFactory.CreateParameter();
            param.ParameterName = dbProvider.BuildParameterName(name);

            return param;
        }

13. Example

Project: Dos.ORM
Source File: Database.cs
View license
private DbParameter CreateParameter(string name)
        {
            DbParameter param = dbProvider.DbProviderFactory.CreateParameter();
            param.ParameterName = dbProvider.BuildParameterName(name);

            return param;
        }

14. Example

Project: Kalman.Studio
Source File: Database.cs
View license
protected DbParameter CreateParameter(string name)
        {
            DbParameter param = _DbProviderFactory.CreateParameter();
            param.ParameterName = BuildParameterName(name);

            return param;
        }

15. Example

Project: anycmd
Source File: RdbDescriptor.cs
View license
public DbParameter CreateParameter()
        {
            if (_dbProviderFactory == null)
            {
                _dbProviderFactory = DbProviderFactories.GetFactory(Database.ProviderName);
            }
            return _dbProviderFactory.CreateParameter();
        }

16. Example

Project: sipsorcery
Source File: SIPAssetPersistor.cs
View license
protected DbParameter GetParameter(DbProviderFactory dbProviderFactory, MetaDataMember member, object parameterValue, string parameterName)
        {
            DbParameter dbParameter = dbProviderFactory.CreateParameter();
            dbParameter.ParameterName = parameterName;
            dbParameter.DbType = EntityTypeConversionTable.LookupDbType(member.DbType);

            if (parameterValue == null)
            {
                dbParameter.Value = null;
            }
            else if (member.Type == typeof(DateTimeOffset) || member.Type == typeof(Nullable<DateTimeOffset>))
            {
                dbParameter.Value = ((DateTimeOffset)parameterValue).ToString("o");
            }
            else
            {
                dbParameter.Value = parameterValue;
            }

            return dbParameter;
        }

17. Example

Project: OrigoDB
Source File: SqlCommandStore.cs
View license
public virtual DbCommand CreateAppendCommand()
        {
            var dbCommand = _providerFactory.CreateCommand();
            dbCommand.CommandText = _statements.AppendEntry;
            
            var param = _providerFactory.CreateParameter();
            param.ParameterName = "@Id";
            param.DbType = DbType.Int64;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Created";
            param.DbType = DbType.DateTime;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Type";
            param.DbType = DbType.String;
            param.Size = 1024;
            dbCommand.Parameters.Add(param);

            param = _providerFactory.CreateParameter();
            param.ParameterName = "@Data";
            param.DbType = DbType.Binary;
            dbCommand.Parameters.Add(param);


            return dbCommand;
        }

18. Example

Project: MIMWAL
Source File: ExpressionFunction.cs
View license
private DbParameter CreateSqlParameter()
        {
            Logger.Instance.WriteMethodEntry(Even/n ..... /n //View Source file for more details /n }

19. Example

Project: DReAM
Source File: DataFactory.cs
View license
internal IDataParameter CreateParameter(object name, object value) {
            IDataParameter result;
            if(_factory != null) {
                result = _factory.CreateParameter();
                result.ParameterName = _parameterChar + name.ToString();
                result.Value = value;
            } else {
                result = (IDataParameter)_parameterConstructor.Invoke(new object[] { _parameterChar + name.ToString(), value });
            }
            return result;
        }

20. Example

Project: DReAM
Source File: DataFactory.cs
View license
internal IDataParameter CreateParameter(object name, object value, ParameterDirection dir) {
            IDataParameter result;
            if(_factory != null) {
                result = _factory.CreateParameter();
                result.ParameterName = _parameterChar + name.ToString();
                result.Value = value;
            } else {
                result = (IDataParameter)_parameterConstructor.Invoke(new object[] { _parameterChar + name.ToString(), value });
            }
            result.Direction = dir;
            return result;
        }

21. Example

Project: Susanoo
Source File: DatabaseManager.cs
View license
public virtual DbParameter CreateParameter()
        {
            return Provider?.CreateParameter() ?? Connection.CreateCommand().CreateParameter();
        }

22. Example

Project: Yarn
Source File: DbFactory.cs
View license
public static DbParameter CreateParameter(DbConnection connection, string name, object value)
        {
            var providerName = GetProviderInvariantNameByConnectionString(connection.ConnectionString);
            if (providerName != null)
            {
                var parameter = DbProviderFactories.GetFactory(providerName).CreateParameter();
                parameter.ParameterName = name;
                parameter.Value = value;
                return parameter;
            }
            return null;
        }

23. Example

Project: Destrier
Source File: Execute.cs
View license
public static void AddParameterToCommand(String name, Object value, DbCommand cmd, DbProviderFactory provider = null, DbType? dbType = null)
            {
                provider = provider ?? DatabaseConfigurationContext.DefaultProviderFactory;

                var dbParameter = provider.CreateParameter();
                dbParameter.ParameterName = String.Format("@{0}", name);
                dbParameter.Value = value.DBNullCoalese();

                if (dbType != null)
                    dbParameter.DbType = dbType.Value;

                cmd.Parameters.Add(dbParameter);
            }

24. Example

Project: Destrier
Source File: Execute.cs
View license
public static void AddParametersToCommandFromProvider(dynamic procedureParams, DbCommand cmd, DbProviderFactory provider = null)
            {
                if (procedureParams == null)
                    return;

                provider = provider ?? DatabaseConfigurationContext.DefaultProviderFactory;

                if (!(procedureParams is IDictionary<String, Object>))
                    procedureParams = ((object)procedureParams).ToDynamic();

                foreach (KeyValuePair<String, Object> member in (IDictionary<String, Object>)procedureParams)
                {
                    object propertyValue = member.Value;
                    var dbParameter = provider.CreateParameter();
                    dbParameter.ParameterName = String.Format("@{0}", member.Key);
                    dbParameter.Value = propertyValue.DBNullCoalese();
                    cmd.Parameters.Add(dbParameter);
                }
            }

25. Example

View license
protected virtual DbCommand GetDbCommand()
        {
            var command = ProviderFactory.Creat/n ..... /n //View Source file for more details /n }

26. Example

Project: Kalman.Studio
Source File: DbTarget.cs
View license
public void Write(LogEntry logEntry)
        {
            ConnectionStringSettings css = Configurat/n ..... /n //View Source file for more details /n }

27. Example

Project: MIMWAL
Source File: ExpressionFunction.cs
View license
[SuppressMessage("Microsoft.Performance", "CA1800:DoNotCastUnnecessarily", Justification = "Reviewed/n ..... /n //View Source file for more details /n }