private MySqlParameter GetParameter(SqlHelperParameter sqlHelperParameter) { MySqlParameter mysqlParameter = new MySqlParameter(); MySqlDbType mysqlDbType = MySqlDbType.VarChar; switch (sqlHelperParameter.DataType) { case ParamsType.Varchar: mysqlDbType = MySqlDbType.VarChar; break; case ParamsType.Int: mysqlDbType = MySqlDbType.Int16; break; case ParamsType.DateTime: mysqlDbType = MySqlDbType.Date; break; case ParamsType.Decimal: mysqlDbType = MySqlDbType.Decimal; break; case ParamsType.Blob: mysqlDbType = MySqlDbType.Blob; break; } mysqlParameter.ParameterName = sqlHelperParameter.Name; mysqlParameter.MySqlDbType = mysqlDbType; mysqlParameter.Direction = sqlHelperParameter.Direction; mysqlParameter.Value = sqlHelperParameter.Value; mysqlParameter.Size = sqlHelperParameter.Size; return(mysqlParameter); }
private OracleParameter GetParameter(SqlHelperParameter sqlHelperParameter) { OracleParameter oracleParameter = new OracleParameter(); OracleDbType oracleDbType = OracleDbType.Varchar2; switch (sqlHelperParameter.DataType) { case ParamsType.Varchar: oracleDbType = OracleDbType.Varchar2; break; case ParamsType.Int: oracleDbType = OracleDbType.Int16; break; case ParamsType.DateTime: oracleDbType = OracleDbType.Date; break; case ParamsType.Decimal: oracleDbType = OracleDbType.Decimal; break; case ParamsType.Blob: oracleDbType = OracleDbType.Blob; break; } oracleParameter.ParameterName = sqlHelperParameter.Name; oracleParameter.OracleDbType = oracleDbType; oracleParameter.Direction = sqlHelperParameter.Direction; oracleParameter.Value = sqlHelperParameter.Value; oracleParameter.Size = sqlHelperParameter.Size; return(oracleParameter); }
private SqlParameter GetParameter(SqlHelperParameter sqlHelperParameter) { SqlParameter sqlParameter = new SqlParameter(); DbType dbType = DbType.String; switch (sqlHelperParameter.DataType) { case ParamsType.Varchar: dbType = DbType.String; break; case ParamsType.Int: dbType = DbType.Int16; break; case ParamsType.DateTime: dbType = DbType.DateTime; break; case ParamsType.Decimal: dbType = DbType.Decimal; break; case ParamsType.Blob: dbType = DbType.Binary; break; } sqlParameter.ParameterName = sqlHelperParameter.Name; sqlParameter.DbType = dbType; sqlParameter.Direction = sqlHelperParameter.Direction; sqlParameter.Value = sqlHelperParameter.Value; sqlParameter.Size = sqlHelperParameter.Size; return(sqlParameter); }
private SQLiteParameter GetParameter(SqlHelperParameter sqlHelperParameter) { SQLiteParameter result = new SQLiteParameter(); return(result); }