LINQ - using linq in asp.net - Asked By Dilip Sharma on 10-Aug-11 06:37 AM

Hi,

Use data-context for this

The DataContext is the source of all entities mapped over a database connection. It tracks changes that you made to all retrieved entities and maintains an "identity cache" that guarantees that entities retrieved more than one time are represented by using the same object instance.

In general, a DataContext instance is designed to last for one "unit of work" however your application defines that term. A DataContext is lightweight and is not expensive to create. A typical LINQ to SQL application creates DataContext instances at method scope or as a member of short-lived classes that represent a logical set of related database operations.

Hope this will help you

LINQ has got a feature SKIP and TAKE which Skips the first few records
specifed and Take the next records specified

var query8 = CustomerList.Select((cust, index) => new { cust, index })
             .Where(c => c.cust.Country == "USA")
             .Select(c => new { c.cust.CustomerID, c.cust.CompanyName, c.index })
             .Skip(10)
             .Take(2);

Try and let me know

i know this...

There are 2 solutions-

1.you can loop through the records, to move to next one...

var Query = from obj in context.tbl_name
              select obj;
       

        foreach (var result in Query)
        {
          //here you can fetch all the rows returned...
        }

2. You can try with Skip() method like this:

Dim products = From p In db.Products Select p
Dim pr As Product = products.Skip(4).First()


Hope it helps...

Thnks skip method is work....

thnkx...

Welcome