MBox-Tutorials

LINQ Query Syntax

LINQ query syntax: from <range variable> in <IEnumerable<T> or IQueryable<T> Collection> <Standard Query Op...

Advantages of LINQ? Familiar language: Developers don’t have to learn a new query language for each type of data source or data format...

what is LINQ? LINQ (Language Integrated Query) is uniform query syntax in C# and VB.NET used to save and retrieve data from different s...

Q: How can you sort a result set based on 2 columns? Assume that you have 2 tables – Product and Category and you want to sort first by c...

What is LINQ? Language-Integrated Query (LINQ) is a set of features in Visual Studio 2008 that extends powerful query capabilities to the...

C# Coding Standards and Guidelines: Naming Conversions and Style 1) Use Pascal casing for type and method and constants. public class SomeC...

C# Coding Standards and Guidelines: Comments 1. All source code must include the following comments at the very top: /****************...

1. Error handler should be present whenever you anticipate possibility of error. 2. Do not use Try-catch for flow- control. 3. Never d...

Coding Standards and Guidelines ASP.NET 1. Prefix user control names with “uc” 2. The rest of the user control name should be in P...

Coding Standards and Guidelines for Database ANSI SQL 92 standards have to be followed for writing queries. Do not put order by...