Please enable Javascript to correctly display the contents on Dot Net Tricks!

Dot Net Tricks Tutorial - For Beginners & Professionals

.net article,c# tutorial,asp.net tutorial,linq tutorial,wcf tutorial,mvc tutorial,entity framework tutorial,sqlserver tutorial,jquery tutorial,visual studio tutorial
 
Author : Shailendra Chauhan
Posted On : 16 Jul 2014

As you know LINQ provides a common query syntax to query any data source and ADO.NET allows you to execute query against any RDBMS like SQL Server, Oracle etc. In this article, I am sharing my view on LINQ and ADO.NET.

 

 

Author : Shailendra Chauhan
Posted On : 16 Jul 2014

LINQ has a JOIN query operator that provides SQL JOIN like behavior and syntax. As you know, Inner join returns only those records or rows that match or exists in both the tables. The simple inner join example is given below:

 

 

Author : Shailendra Chauhan
Posted On : 16 Jul 2014

LINQ provides element operators which return a single element or a specific element from a collection. The elements operators are Single, SingleOrDefault, First, FirstOrDefault, Last, LastOrDefault.

 

 

Author : Shailendra Chauhan
Posted On : 16 Jul 2014

LINQ provides a uniform programming model (i.e. common query syntax) to query data sources (like SQL databases, XML documents, ADO.NET Datasets, Various Web services and any other objects such as Collections, Generics etc.). LINQ provides you three different ways to write a LINQ query in C# or VB.

 

 

Author : Shailendra Chauhan
Posted On : 16 Jul 2014

LINQ provides a common query syntax to query any data source. In a LINQ query, you always work with objects. The object may in-process object or out-process object. Based on objects, LINQ query expression is translated and executed.

 

 

Author : Shailendra Chauhan
Posted On : 16 Jul 2014

Select and SelectMany are projection operators. Select operator is used to select value from a collection and SelectMany operator is used to select values from a collection of collection i.e. nested collection.

 

 

Author : Shailendra Chauhan
Posted On : 12 Jul 2014

In .NET, Expression is an abstract class which contains static methods and inherited by various types (like ParameterExpression, MethodCallExpression) to create expression tree nodes of specific types. A ParameterExpression represents a named parameter expression and a MethodCallExpression represents a method call.

 

 

Author : Shailendra Chauhan
Posted On : 24 Jun 2014

Microsoft Visual Studio Express products are powerful and reliable free development IDE that provide a free development environment to develop applications for the latest platforms. The Express edition is free and ideal for learning, developing, powering desktop, web & small server applications.

 

 

Author : Shailendra Chauhan
Posted On : 03 Jun 2014

LINQ provided you common query syntax to query various data sources like SQL Server, Oracle, DB2, WebServices, XML and Collection etc. LINQ also has full type checking at compile-time and IntelliSense support in Visual Studio, since it used the .NET framework languages like C# and VB.NET.

 

 

Author : Shailendra Chauhan
Posted On : 19 May 2014

Microsoft has announced the next generation of ASP.NET at TechEd North America on 12 May 2014, which is called ASP.NET vNext. ASP.NET vNext includes new cloud optimized versions of MVC6, Web API3, Web Pages4, SignalR3 and Entity Framework7.

 

 

Author : Shailendra Chauhan
Posted On : 01 May 2014

ASP.NET MVC5 and WEB API 2 supports a new type of routing, called attribute routing. In this routing, attributes are used to define routes. Attribute routing provides you more control over the URIs by defining routes directly on actions and controllers in your ASP.NET MVC application and WEB API.

 

 

Author : Shailendra Chauhan
Posted On : 28 Apr 2014

Decision making statements help you to make decision based on certain conditions. These conditions are specified by a set of decision making statements having boolean expressions which are evaluated to a boolean value true or false. There are following types of decision making statements in C#.

 

 

Author : Shailendra Chauhan
Posted On : 06 Apr 2014

Ref and out parameters are used to pass an argument within a method. In this article, you will learn the differences between these two parameters.

 

 

Author : Shailendra Chauhan
Posted On : 02 Apr 2014

JavaScript is a dynamic language. You can create objects on the fly, and objects can contain other objects, also it does not support the concept of namespace like C#.

 

 

Author : Shailendra Chauhan
Posted On : 02 Apr 2014

JavaScript is a prototype-based programming language which has no class like as C++, C#, Java etc. JavaScript uses functions as classes. Hence, in JavaScript we can define a class name Student as given below-

 

 

 
 
23 MAY
Xamarin Forms : Build Cross-platform Apps (Online)

09:00 PM-11:00 PM IST(+5.30 GMT)

Know More
6 MAY
Angular2 and Angular4 Development (Online)

08:00 AM-10:00 AM IST(+5.30 GMT) Weekend

Know More
6 MAY
NodeJS with Angular4 Development (Classroom)

5:00 PM-6:30 PM

Know More
5 MAY
ASP.NET MVC with Angular4 Development (Online)

06:30 AM-08:30 AM IST(+5.30 GMT)

Know More
2 MAY
ASP.NET Core Development (Online)

07:00 AM - 09:00 AM IST( TUS, THR)

Know More
29 APR
ASP.NET MVC with Angular2 Development (Classroom)

9:30 AM-11:00 AM

Know More
29 APR
ASP.NET MVC with Angular2 Development (Classroom)

9:30 AM-11:00 AM

22 APR
NodeJS Development (Classroom)

11:00 AM-12:30 PM

10 APR
Master Class ASP.NET MVC 5 with Angular2 Plus Angular4 Development (Online)

09:00 PM - 11:00 PM IST (M/W/F)

8 APR
MEAN Stack 2 Development (Classroom)

11:00 AM-12:30 PM

25 MAR
Xamarin Forms : Build Cross-platform Apps (Classroom)

8:00 AM-9:30AM

21 MAR
ASP.NET MVC with Angular2 Development (Online)

09:00 PM - 11:00 PM IST( TUS, THR, SAT)

25 FEB
ASP.NET MVC with Angular2 Development (Classroom)

03:30 PM-05:30 PM

24 FEB
Angular 2 with Type Script (Online)

09:00 PM-11:00 PM IST(Mon,Wed,Fri)

BROWSE BY CATEGORY
 
 
LIKE US ON FACEBOOK
 
+