linq in asp.net
TRANSCRIPT
![Page 1: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/1.jpg)
![Page 2: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/2.jpg)
Muhammed Ajmal
www.facebook.com/ajuik2008
twitter.com/username
in.linkedin.com/in/profilename
9745020951
LINQ
![Page 3: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/3.jpg)
Disclaimer: This presentation is prepared by trainees ofbaabtra as a part of mentoring program. This is not officialdocument of baabtra –Mentoring PartnerBaabtra-Mentoring Partner is the mentoring division of baabte System Technologies Pvt . Ltd
![Page 4: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/4.jpg)
Introduction
• LINQ stands for Language-Integrated Query
• It is simply a unified programming model for writing
SQL queries in simple language(C#,VB,etc) without
learing SQL.
![Page 5: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/5.jpg)
LINQ contd..
• It has a single unitive syntax for querying multiple
data sources.
• It uses a declarative syntax that allows developers to
tell the compiler what to do.
![Page 6: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/6.jpg)
Structure of LINQ
![Page 7: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/7.jpg)
How Write Linq query ?
Var variablename=
from tempvariable
in dataSource
Where condition
Select columns
![Page 8: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/8.jpg)
Stages of the Query
1. Obtain the data source for the query
2. Create the query
3. Execute query
![Page 9: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/9.jpg)
Advantage
• LINQ syntax is same, when querying multiple data
sources.
• it provides syntax highlighting.
![Page 10: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/10.jpg)
Example 1
create dataContext class
![Page 11: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/11.jpg)
Datacontext class
![Page 12: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/12.jpg)
Data from db
![Page 13: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/13.jpg)
output
![Page 14: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/14.jpg)
Data From object
![Page 15: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/15.jpg)
Contd..
![Page 16: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/16.jpg)
Thank you
![Page 17: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/17.jpg)
Want to learn more about programming or Looking to become a good programmer?
Are you wasting time on searching so many contents online?
Do you want to learn things quickly?
Tired of spending huge amount of money to become a Software professional?
Do an online course @ baabtra.com
We put industry standards to practice. Our structured, activity based courses are so designedto make a quick, good software professional out of anybody who holds a passion for coding.
![Page 18: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/18.jpg)
Follow us @ twitter.com/baabtra
Like us @ facebook.com/baabtra
Subscribe to us @ youtube.com/baabtra
Become a follower @ slideshare.net/BaabtraMentoringPartner
Connect to us @ in.linkedin.com/in/baabtra
Give a feedback @ massbaab.com/baabtra
Thanks in advance
www.baabtra.com | www.massbaab.com |www.baabte.com
![Page 19: Linq in asp.net](https://reader030.vdocuments.us/reader030/viewer/2022021422/5a66c3107f8b9a817e8b489f/html5/thumbnails/19.jpg)
Emarald Mall (Big Bazar Building)Mavoor Road, Kozhikode,Kerala, India.Ph: + 91 – 495 40 25 550
NC Complex, Near Bus StandMukkam, Kozhikode,Kerala, India.Ph: + 91 – 495 40 25 550
Cafit Square,Hilite Business Park,Near Pantheerankavu,Kozhikode
Start up VillageEranakulam,Kerala, India.
Email: [email protected]
Contact Us