public IEnumerable <Category> QueryCategories(TextContent content) { List <Category> list = new List <Category>(); MySqlConnection connection; using (var dataReader = MysqlHelper.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 <IDictionary <string, object> > ExportSchemaData(Schema schema) { string sql = string.Format("SELECT * FROM `{0}` ", schema.GetTableName()); List <TextContent> list = new List <TextContent>(); MySqlConnection connection; using (var reader = MysqlHelper.ExecuteReader(schema.Repository, new MySqlCommand() { CommandText = sql }, out connection)) { while (reader.Read()) { list.Add(reader.ToContent <TextContent>(new TextContent())); } 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>(); MySqlConnection connection; using (var reader = MysqlHelper.ExecuteReader(repository, new MySqlCommand() { CommandText = sql }, out connection)) { 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); } connection.Close(); } return(list); }