public IEnumerable <Category> QueryCategories(TextContent content) { List <Category> list = new List <Category>(); SqlConnection connection; using (var dataReader = SQLServerHelper.ExecuteReader(content.GetRepository(), dbCommands.QueryCategories(content), out connection)) { try { while (dataReader.Read()) { Category category = new Category() { CategoryFolder = dataReader.GetString(dataReader.GetOrdinal("CategoryFolder")), CategoryUUID = dataReader.GetString(dataReader.GetOrdinal("CategoryUUID")), ContentUUID = dataReader.GetString(dataReader.GetOrdinal("UUID")), }; list.Add(category); } } finally { dataReader.Close(); connection.Close(); } } return(list); }
public IEnumerable <Category> ExportCategoryData(Repository repository) { string sql = string.Format("SELECT UUID,CategoryFolder,CategoryUUID FROM [{0}] ", repository.GetCategoryTableName()); List <Category> list = new List <Category>(); SqlConnection connection; using (var reader = SQLServerHelper.ExecuteReader(repository, new SqlCommand() { CommandText = sql }, out connection)) { try { while (reader.Read()) { Category category = new Category(); category.ContentUUID = reader.GetString(0); category.CategoryFolder = reader.GetString(1); category.CategoryUUID = reader.GetString(2); list.Add(category); } } finally { reader.Close(); connection.Close(); } } return(list); }
public IEnumerable <IDictionary <string, object> > ExecuteQuery(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; List <IDictionary <string, object> > list = new List <IDictionary <string, object> >(); SqlConnection connection; using (var dataReader = SQLServerHelper.ExecuteReader(repository, command, out connection)) { try { while (dataReader.Read()) { TextContent content = new TextContent(); dataReader.ToContent(content); list.Add(content); } } finally { dataReader.Close(); connection.Close(); } } return(list); }
public IEnumerable <IDictionary <string, object> > ExportSchemaData(Schema schema) { string sql = string.Format("SELECT * FROM [{0}] ", schema.GetTableName()); List <IDictionary <string, object> > list = new List <IDictionary <string, object> >(); SqlConnection connection; using (var reader = SQLServerHelper.ExecuteReader(schema.Repository, new SqlCommand() { CommandText = sql }, out connection)) { try { while (reader.Read()) { list.Add(reader.ToContent <TextContent>(new TextContent())); } } finally { reader.Close(); connection.Close(); } } return(list); }