Posts

Showing posts with the label Entity Framework

pagination in C# skip and take using entity framwork

 int skip = (pageNumber - 1) * pageSize;             searchText = searchText.ToUpper();             var data = DbContext.BINRegisters.Where(m => m.BINNo.ToUpper().Contains(searchText)                 || m.BINType.ToUpper().Contains(searchText)                 ).Skip(skip).Take(pageSize).ToList();             return data;

Get Auto generated ID using c# & entity Framwork with prefix

 string prefix = "PO";                 string a = "0000000001";                 string invNo = prefix + a;                 var inv = (from p in db.PurchaseOrders                            where p.PONO.Contains(prefix)                            orderby p.ID descending                            select p.PONO).FirstOrDefault();                 if (inv != null)                 {                     a = inv.Substring(prefix.Length);                     invNo = prefix + (Co...

Group by on multiple column in LINQ (Query Method)

var query = source . GroupBy ( x => new { x . Column1 , x . Column2 }); List < Element > elements = new List < Element >() { new Element { Company = "JPMORGAN CHASE" , TypeOfInvestment = "Stocks" , Worth = 96983 }, new Element { Company = "AMER TOWER CORP" , TypeOfInvestment = "Securities" , Worth = 17141 }, new Element { Company = "ORACLE CORP" , TypeOfInvestment = "Assets" , Worth = 59372 }, new Element { Company = "PEPSICO INC" , TypeOfInvestment = "Assets" , Worth = 26516 }, new Element { Company = "PROCTER & GAMBL" , TypeOfInvestment = "Stocks" , Worth = 387050 }, new Element { Company = "QUASLCOMM INC" , TypeOfInvestment = "Bonds" , Worth =...