/// <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();
}