private static bool CheckTableExists(Schema schema) { string sql = string.Format(@"SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = '{0}'", schema.GetTableName()); SqlCommand command = new SqlCommand() { CommandText = sql }; return((int)SQLServerHelper.ExecuteScalar(schema.Repository, command) != 0); }
public object ExecuteScalar(Repository repository, string queryText, System.Data.CommandType commandType = System.Data.CommandType.Text, params KeyValuePair <string, object>[] parameters) { var command = new System.Data.SqlClient.SqlCommand(queryText); if (parameters != null && parameters.Length > 0) { command.Parameters.AddRange(parameters.Select(it => new SqlParameter() { ParameterName = it.Key, Value = it.Value }).ToArray()); } command.CommandType = commandType; return(SQLServerHelper.ExecuteScalar(repository, command)); }