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