Show 10 million records at a time using linq and ORM

Use a grid that supports server side paging.

Most all of the commercial grids support it out of the box.

The standard .NET DataGridView can be made to do the same with a little work, as far as I remember.

You don't want to load all 10m records, you want to load pages at a time and have the rows fetched on-demand.

I recommend DevExpress, Telerik, C1 or SyncFusion's grids.

>>I need to show 10 million records at a time using datagrid<<
That makes no sense whatsoever:  No user in their right mind will navigate through 1000 rows, let alone 10 million.

I NEED 10 million records to be showed at a time. What would you recommend? DataGridView works too slow, so I need a faster solution from Object Relational Management system.

to do realtional mangememt sytem You wo'nt require datagrid. Write a dbms like sql server,Oracle or Access

my personal opinion: there is no FAST way to show all 10mil. records at once... you will have performance problems no matter what data access you use or ORM.

I also agree with acperkins comment... no user can (see / look ) at all records at a time...
Showing your data by splitting to pages will be the best...

OK, I understand that I will have some performance problems and no user will look at all records, but I need to find-out the fastest way to do so.

So you've ignored my original suggestion.

You should use a quality grid control with server side paging.

To mrjoltcola: I cannot use commercial grids.