/// <summary> /// /Create Sql Command /// </summary> /// <param name="commandText"></param> /// <param name="cmdType"></param> /// <param name="collection"></param> /// <returns></returns> public CSqlDbCommand CreateCommand(string commandText, CommandType cmdType, CSqlDbParameterCollection collection) { var cmd = new CSqlDbCommand(commandText, cmdType); cmd.Parameters = collection; Parameters = cmd.Parameters; return(cmd); }
/// <summary> /// Set Parameter all properties /// </summary> /// <param name="dbParameters"></param> /// <returns></returns> private SqlParameter[] GetParametersWithNativeType(CSqlDbParameterCollection dbParameters) { SqlParameter[] paramArray = new SqlParameter[dbParameters.Count]; for (int i = 0; i < dbParameters.Count; i++) { paramArray[i] = new SqlParameter("@" + dbParameters[i].ParameterName, (dbParameters[i].Value == null) ? DBNull.Value : dbParameters[i].Value); paramArray[i].Direction = dbParameters[i].Direction; paramArray[i].Size = dbParameters[i].Size; paramArray[i].DbType = dbParameters[i].DbType; } return(paramArray); }
public CSqlDbCommand() { _paramterCollection = new CSqlDbParameterCollection(); }
/// <summary> /// Connection Initialization /// </summary> public override void Initialize() { //default set to procedure _sqlCon = new SqlConnection(_connectionString); _sqlParamCollection = new CSqlDbParameterCollection(); }