Creating data table programmatically in C#

Sometimes we need to create the data table programmatically in code behind. Here I am giving you a simple example of creating data table programmatically in C#.

Select random records from database (MySQL, Oracle, MS SQL)

Sometimes we need to select random records from a table in our database. For example, if you created online test application then every time we need to get the random questions from our questions table.

Today I will give you some examples for selecting random records in some popular databases.

LINQ Operators:Partition Operators

This post is the part of series called LINQ Operators that brings the practical examples of LINQ operators. In previous posts we have learned about Filtering and Projection operators.Today we will see the Partition Operators in LINQ.

 

LINQ Operators: Projection Operators

In previous article we discussed about Filtering operators in LINQ. So moving forward today we will see the Projection Operators in LINQ. 

LINQ Operators : Filtering Operators

LINQ operators are a collection of methods that form the heart and soul of the LINQ(Language Integrated Query). The best thing of these operators is how they can execute against different data sources. You can use these operators not only to query object in memory but you can use same operators to query object stored in relational database, in XML, datasets and more.