public void Update() { OrmEngine.Instance().InitializeDatabase(); AutoContext db = new AutoContext(); DAIList<Category> categories = db.Category.ToList(); Category category = categories[0]; category.CategoryName = "pc3"; db.Category.Update(category); //provider.Update(new Product() { Id = 2, ProductCode = "Ali", ProductName= "Kaya" }); db.SaveChanges(); }
public void ContextExtensionTest() { ConfigurationManager.ConnectionStrings["DEFAULT"].ToString(); AutoContext db = new AutoContext(); DAIList<Category> cats = db.Category.Where(i=> i.Id == 8).ToList(); DbContext a = new DbContext(); a.Adi = "dai"; a.TransformText(); }
public void WhereClause() { AutoContext db = new AutoContext(); DAIList<Product> products = new DAIList<Product>(); products = db.Product.Where(i => i.Id == 1 && i.ProductName == "Mac" || i.CategoryId != 3).ToList(); }
public void RelationMap() { AutoContext db = new AutoContext(); DAIList<Product> products = db.Product.ToList(); DAIList<Category> cat = products[0].Categories; }
public void SkipTake() { DAIList<Category> cats = new AutoContext().Category.ToList().Skip(1).Take(2); }
public void Skip() { DAIList<Product> product = new AutoContext().Product.ToList().Skip(1); }
public void Take() { DAIList<Product> product = new AutoContext().Product.Take(1); }
public void First() { AutoContext db = new AutoContext(); Category dai = db.Category.First(); }
public void Last() { AutoContext db = new AutoContext(); //Product p = db.Product.Last(); }
public void Sum() { AutoContext db = new AutoContext(); decimal sumID = db.Product.Sum(c => c.Id); }
public void GroupBy() { AutoContext db = new AutoContext(); DAIList<Category> cats = db.Category.GroupBy(i => i.CategoryName); }
public void Avg() { AutoContext db = new AutoContext(); decimal avg = db.Product.Avg(i => i.Id); }
public void OrderByDesc() { AutoContext db = new AutoContext(); DAIList<Product> prs = db.Product.OrderByDescending(i => i.ProductName); }
public void Min() { AutoContext db = new AutoContext(); decimal minId = db.Product.Min(p => p.Id); }
public void Max() { AutoContext db = new AutoContext(); decimal maxId = db.Category.Max(p => p.Id); }
public void LastFieldValue() { AutoContext db = new AutoContext(); //string lastCatName = db.Category.LastFieldValue("CategoryName").ToString(); }
public void CodeGeneration() { List<Category> dai = new List<Category>(); //Category a = new Category(); //a.CategoryCode = "dai"; //DbContext context = new DbContext(); //OrmEngine.Instance().InitializeDatabase(); //Product b = new Product(); //b.ProductCode = "a"; //context.Product.Add(b); //DAIList<Product> cat = context.Product.Where(p => p.ProductCode == "a"); AutoContext db = new AutoContext(); DAIList<Category> cat = db.Category.Where(p => p.CategoryName == "mac"); DAIList<Product> Products = db.Product.ToList().OrderByDescending(p => p.Id); Product a = Products[0]; var b = a.Categories; }
public void SaveChanges() { AutoContext db = new AutoContext(); db.Category.AddItem(new Category() { CategoryCode = "cd", CategoryName = "dvd" }); db.SaveChanges(); }