protected ADODB.Command GenerateCommand(CommandTypeEnum eCmdType, SqlFrag frag) { ADODB.Command SqlCmd = new Command(); string strQuery = ""; if (frag.SqlParams.Count < 2040) { ProcessParameters(SqlCmd, frag); // replace our tags strQuery = frag.m_strSql.Replace("{", ""); strQuery = strQuery.Replace("}", ""); } else { strQuery = frag.Flatten(); } // ensure we have a valid connections Ensure(); // set up the object SqlCmd.ActiveConnection = m_pConnection; SqlCmd.CommandText = strQuery; SqlCmd.CommandType = eCmdType; return(SqlCmd); }
public DataSet GetDataSet(SqlFrag frag) { if (frag.SqlParams.Count < 2040) { return(GetParamDataSet("{SQL}", frag)); } else { return(GetParamDataSet(frag.Flatten())); } }
public SqlDataReader GetDataReader(SqlFrag frag) { if (frag.SqlParams.Count < 2040) { return(GetParamDataReader("{SQL}", frag)); } else { return(GetParamDataReader(frag.Flatten())); } }
public int ExecuteSql(SqlFrag frag) { if (frag.SqlParams.Count < 2040) { return(ExecuteParamSql("{SQL}", frag)); } else { return(ExecuteParamSql(frag.Flatten())); } }