asp.net core docker Part 1 What is LINQ

Text version of the video
http://csharp-video-tutorials.blogspo...

Slides
http://csharp-video-tutorials.blogspo...

LINQ Tutorial - All Text Articles & Slides
http://csharp-video-tutorials.blogspo...

LINQ Tutorial Playlist
https://www.youtube.com/playlist?list...

Dot Net, SQL, Angular, JavaScript, jQuery and Bootstrap complete courses
https://www.youtube.com/user/kudvenka...

In this video, we will discuss
1. What is LINQ
2. Why should we use LINQ and what are the benefits of using LINQ
3. LINQ Architecture
4. LINQ Providers
5. LINQ to SQL Example

What is LINQ
LINQ stands for Language Integrated Query. LINQ enables us to query any type of data store (SQL Server, XML documents, Objects in memory etc).

Why should we use LINQ and what are the benefits of using LINQ
If the .NET application that is being developed
a) Requires data from SQL Server - Then the developer has to understand ADO.NET code and SQL specific to SQL Server Database
b) Requires data from an XML document - Then the developer has to understand XSLT & XPATH queries
c) Need to query objects in memory (List[Customer], List[Order] etc) - Then the developer has to understand how to work with objects in memory

LINQ enables us to work with these different data sources using a similar coding style without having the need to know the syntax specific to the data source. In our upcoming videos we will discuss querying different data sources using LINQ.

Another benefit of using LINQ is that it provides intellisense and compile time error checking.

LINQ Architecture & LINQ Providers
1. LINQ query can be written using any .NET supported programming language
2. LINQ provider is a component between the LINQ query and the actual data source, which converts the LINQ query into a format that the underlying data source can understand. For example LINQ to SQL provider converts a LINQ query to T-SQL that SQL Server database can understand.

If we misspell table or column names in the SQL Query, we will not know about it at compile time. At run time the page crashes and that's when we will know about this error. Also notice that there is no intellisense when typing table and column names. Misspelled column names when reading from the reader will also cause the same problem. With LINQ we will have intellisense and compile time error checking.

With LINQ we get intellisense. If we misspell the table or column names we will get to know about them at compile time.

asp.net core docker Part 1 What is LINQ
1,170 Likes	1,170 Dislikes
431,048 views views	524K followers
Education	Upload TimePublished on 28 Jun 2014

Related keywords

wcf vs web api,ado.net core,sql server management studio,webkinz,webadvisor,craigslist nj,wcf one piece,asp.net core 3,ajax players,beginners drawing,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,services angular,ajax ontario,asp.net mvc tutorial,beginners yoga near me,.net framework 4.6.1,asp.net cos'è,.net framework 4.6.2,csharp assembly,tutorialspoint python,sql join,services briefcase,asp.net core web api,ajax jquery,wccftech,craigslist ny,asp.net zero,csharp foreach,server memes,sql date format,services online,chase,beginners makeup,serverless architecture,server resume,wcf c#,server books,tutorialspoint javascript,mvcc connect,ado.net mysql,services technologies gps,beginners running plan,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,.net 3.5,tutorialspoint spring,serverless,wcf soap,.net framework 4.5.2,wcf cat,cool math games,wcf test client,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,mvconnect,cunyfirst,asp.net guida,beginners surfboard,wcf nba,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,http://asp.net,server 2019,chernobyl,ado.net descargar,web of dreams,serverminer,ajax cleaner,ado.net visual studio 2019,webassign,ado.net vs entity framework,beginners sewing machine,ado.net visual studio 2017,csharp list,beginners yoga poses,sql like,asp.net mvc,asp.net core tutorial,sqlite,beginners yoga,wcfm,ajax roster,mvc architecture,http://ado.net,beginners guide to investing,asp.net core mvc,ajax soccer,server hosting,wcfi,ajax dish soap,beginners keto diet,capital one,server rack,tutorialspoint html,csharp interface,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,tutorialspoint python 3,sql developer,webster,beginners movie,services transmission company sas,sql group by,asp.net core signalr,services manager,beginners credit card,mvc framework,ajax paving,mvc near me,tutorialspoint spring boot,.net framework 4.7.2,mvc map,csharp online compiler,asp.net download,sql between,ado.net c# pdf,services tag dell,wcf 2019 nba,csharp switch,ado.net ventajas y desventajas,csharpstar,beginners bible,wcf tutorial,tutorialspoint,ajax meaning,csharp-video-tutorials.blogspot,tutorials dojo,central park 5,csharp string format,ado.net c#,asp.net core github,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,server error in '/' application,.net que es,services windows,asp.net core 3.0,sql injection,tutorialspoint c#,wcf ria services,calculator,ado.net entity data model,sql insert,tutorialspoint tableau,services google play apk,sqlyog,asp.net core 3 release date,sql server,server job description,tutorials by a,servicenow,.net framework 4.7,.net core 3,webcam,.net framework 4.8,.net framework 4.5,mvc hours,.net framework 4.6,webmd symptom,csharp array,.net framework 4.0,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,.net framework 3.5 sp1,asp.net core,server pro,server status ffxiv,beginner's mind,cheap flights,webcrims,asp.net core hosting,services sas,tutorialspoint java,tutorialspoint java compiler,webmd,.net framework,csharp to json,college football,ado.net dataset,csharp dictionary,cnn,website builder,tutorialspoint sql,asp.net web api,server side rendering,weber grills,sql server 2017,tutorialspoint spark,mvc nj,ado.net oracle,asp.net core download,csharp to vb.net,webster bank,.net framework 3.5,webstaurant,tutorialsystems,ajax post,services fms publish announcement,services.msc no abre,ajax jersey,csharp operator,asp.net core razor pages,server duties,asp.net core environment variables,csharp random,century 21,.net framework 3.5 windows 10,beginners meditation,services consultores,services consulting,mvcsd,services.msc,mvcsc,ado.net pdf,asp.net core configuration,ajax marvel,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,beginners golf clubs,chase online,.net core,wcf api,costco,beginners guide to the end,server jobs near me,webex,.net framework 2.0,sql meaning,sql tutorial,sql commands,ado.net entity framework,.net framework 4,ajax tavern,tutorialsteacher,ajax javascript,services desk,beginners crochet,ajax greek,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,beginners guitar,.netflix,asp.net core middleware,beginners workout,wcf web service,mvc webadvisor,web store,mvcc,webmail,mvci,mvctc,