Best method to retrieve millions of records using LINQ?
Could you please explain what are the best methods to retrieve millions of recors from sqlserver using linq?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Shahriar NikkhahPosted Apr 23, 2018, 9:46 AM
- Study/understand your source table and manlys it data patern
- Find a field or fields that can play a role of a point in time
- One field example: a field with identity
- Multiple fields example: CreateDate, ModifyDate
- Use that field as an incremental loading process
- save you last record load from the above field for the next load so you won't have to do a reload of millions of record.
Good luckRamesh PalanivelPosted Apr 23, 2018, 5:55 AM
Sasi RekhaPosted Apr 23, 2018, 5:46 AM
Ramesh PalanivelPosted Apr 23, 2018, 5:44 AM
Sasi RekhaPosted Apr 23, 2018, 5:40 AM
Ramesh PalanivelPosted Apr 23, 2018, 5:37 AM
Sasi RekhaPosted Apr 23, 2018, 5:26 AM
Ramesh PalanivelPosted Apr 23, 2018, 5:19 AM