public void Test() { ProcedureDatabase db; db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider)); int count; db.GetCategoriesCount(out count); Assert.AreEqual(db.Categories.Count(), count); var id = db.Categories.Max(o => o.CategoryID); string name; db.GetCategoryName(id, out name); Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Single().CategoryName, name); OracleRefCursor myrc; db.Connection.Open(); db.GetAllCategories(out myrc); var reader = myrc.GetDataReader(); IEnumerable <Category> categories = db.Translate <Category>(reader).ToArray(); Assert.AreEqual(db.Categories.Count(), categories.Count()); db.Connection.Close(); categories = db.GetAllCategories(); Assert.AreEqual(db.Categories.Count(), categories.Count()); }
public void GetAllCategores() { var db = new ProcedureDatabase(); var items = db.GetCategories().ToArray(); Assert.AreEqual(db.Categories.Count(), items.Count()); }
public void AddCategory() { var db = new ProcedureDatabase(); var id = db.Categories.Max(o => o.CategoryID) + 1; db.AddCategory(id, "Name" + id, "Description" + id); }
public void CreateDatabase() { var db = new ProcedureDatabase(); FbConnection.DropDatabase(db.Connection.ConnectionString); db.CreateDatabase(); }
public void GetAllCategories() { var db = new ProcedureDatabase(); object myrc; var items = db.GetAllCategories(out myrc); Assert.AreEqual(db.Categories.Count(), items.Count()); }
public void GetCategoriesCount() { var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider)); int count; db.GetCategoriesCount(out count); Assert.AreEqual(db.Categories.Count(), count); }
public void GetCategoriesCount() { var db = new ProcedureDatabase(); int count; db.GetCategoriesCount(out count); Assert.AreEqual(db.Categories.Count(), count); }
public void GetCategoryName2() { var db = new ProcedureDatabase(); var id = db.Categories.Max(o => o.CategoryID); var name = db.Categories.Where(o => o.CategoryID == id).Select(o => GetCategoryName2(o.CategoryID)).Single(); Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Select(o => o.CategoryName).Single(), name); }
public void GetCategoryPicture3() { var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider)); //var id = 2; db.Connection.Open(); //var pic = db.DUAL.Select(o => GetCategoryPicture(id)).Single(); db.Connection.Close(); }
public void GetCategoryPicture2() { var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider)); db.Connection.Open(); var pics = db.Categories.Select(o => GetCategoryPicture(o.CategoryID)).ToArray(); db.Connection.Close(); }
public void AddCategory() { var db = new ProcedureDatabase(); var count = db.Categories.Count(); var id = db.Categories.Max(o => o.CategoryID) + 1; db.AddCategory(id, "Name", "Description"); Assert.AreEqual(count + 1, db.Categories.Count()); }
public void GetAllCategories() { var db = new ProcedureDatabase(); string categoryName, categoryDescription; int categoryID; var items = db.GetAllCategories(out categoryID, out categoryName, out categoryDescription); Assert.AreEqual(db.Categories.Count(), items.Count()); }
public void GetCategoryName() { var db = new ProcedureDatabase(); var id = db.Categories.Max(o => o.CategoryID); string name; db.GetCategoryName(id, out name); Assert.AreEqual(db.Categories.Where(o => o.CategoryID == id).Single().CategoryName, name); }
public void GetCategories() { var db = new ProcedureDatabase { Log = Console.Out }; var categories = db.GetCategories(); Assert.Equals(db.Categories.Count(), categories.Count()); }
public void AddCategory() { var db = new ProcedureDatabase { Log = Console.Out }; var count = db.Categories.Count(); db.AddCategory("name", "description"); Assert.AreEqual(count + 1, db.Categories.Count()); }
public void CreateProcedure3() { var command = @"Create PROCEDURE GetCategoryName AS Select CategoryName From Categories Where CategoryID = [@categoryID]"; var db = new ProcedureDatabase(); db.ExecuteCommand(command); }
public void CreateDatabase() { var db = new ProcedureDatabase(); if (db.DatabaseExists()) { db.DeleteDatabase(); } db.CreateDatabase(); }
public void GetCategoryName() { var db = new ProcedureDatabase { Log = Console.Out }; var maxID = db.Categories.Max(c => c.CategoryID); var category = db.Categories.Where(o => o.CategoryID == maxID).Single(); var categoryName = db.GetCategoryName(category.CategoryID); Assert.AreEqual(category.CategoryName, categoryName); }
public void AddProduct() { var db = new ProcedureDatabase(); var id = db.Products.Max(o => o.ProductID) + 1; db.Products.Insert(new Product { ProductID = id, ProductName = "Name" }); }
public void GetCategoryPicture1() { var db = new ProcedureDatabase(typeof(ALinq.Oracle.Odp.OracleProvider)); var id = 2; db.Connection.Open(); var pic = db.GetCategoryPicture(id); db.Connection.Close(); Assert.IsNotNull(pic); }
public void GetPictures() { var db = new ProcedureDatabase(); var ids = db.Categories.Select(o => o.CategoryID).ToArray(); //ids.Select(o => db.GetCategoryPicture(o, out pic)).ToArray(); foreach (var id in ids) { byte[] pic; db.GetCategoryPicture(id, out pic); } }
public void CreateDatabase() { var db = new ProcedureDatabase() { Log = Console.Out }; if (db.DatabaseExists()) { db.DeleteDatabase(); } db.CreateDatabase(); }
public void GetCategoriesAndProducts() { var db = new ProcedureDatabase(); object myrc1; object myrc2; var result = db.GetCategoriesAndProducts(out myrc1, out myrc2); var categories = result.GetResult <Category>(); Assert.AreEqual(db.Categories.Count(), categories.Count()); var products = result.GetResult <Product>(); Assert.AreEqual(db.Products.Count(), products.Count()); }
public void GetCategoresAndProducts() { var db = new ProcedureDatabase(); var result = db.GetCategoriesAndProducts(); var categories = result.GetResult <Category>().ToArray(); var products = result.GetResult <Product>().ToArray(); foreach (var category in categories) { Console.WriteLine("{0} {1} {2}", category.CategoryID, category.CategoryName, category.Description); } Assert.AreEqual(db.Categories.Count(), categories.Count()); Assert.AreEqual(db.Products.Count(), products.Count()); }
public void CreateProcedure1() { var sb = new StringBuilder(); sb.AppendLine("DROP PROCEDURE IF EXISTS ADD_CATEGORY;"); sb.AppendLine("CREATE PROCEDURE ADD_CATEGORY(IN CATEGORY_NAME VARCHAR(30), IN CATEGORY_DESCRIPTION TEXT)"); sb.AppendLine("BEGIN"); sb.AppendLine("INSERT INTO CATEGORIES (CategoryName, Description)"); sb.AppendLine("Values (category_name, category_description);"); sb.AppendLine("END;"); sb.AppendLine(); var db = new ProcedureDatabase(); db.ExecuteCommand(sb.ToString()); }