Linq to SQL

Linq to SQL


Referring to http://www.revenmerchantservices.com/page/Linq-to-Sql.aspx

Filter Items into DB using Linq to SQl


Create DataBaseContext objct
AdventureWorksDataContext advDBc = new AdventureWorksDataContext();

var query = from entities in advDBc.Products   // select entities from product

where entities.Name.StartsWith("B")       // This will give all products starting with B

select entities;    // all linq statements must end with select or groupby clauses

GridView1.DataSource = query;

GridView1.DataBind();

 

Linq Group By Multiple ColumnsLinq-to-SQL-Insert-syntexLinq to SQLLinq Split String To ListLinq Inner JoinLearn Linq Step By StepLinq Distinct ListHow to select multiple columns in Linq- C#.net VB.net codeSql Server MirroringLinq Get Duplicate Count Of Words From StringLinq Union and intersect Example

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.