public void ExecuteNonQuery(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; SQLServerHelper.ExecuteNonQuery(repository, command); }
public void ImportCategoryData(Repository repository, IEnumerable <Category> data) { SQLServerHelper.ExecuteNonQuery(repository, data.Select(it => dbCommands.AddCategory(repository, it)).ToArray()); }
public void ImportSchemaData(Schema schema, IEnumerable <IDictionary <string, object> > data) { SQLServerHelper.ExecuteNonQuery(schema.Repository, data.Select(it => dbCommands.Add(GetContent(schema, it))).Where(it => it != null).ToArray()); }