I am using a DataTable in my application with Linq for insertion, updation and Deletion. I have used the nos. and name of column same as in Database.
I want to convert this DataTable into Generic List and then Insert all record in Database with InsertAllonSubmit.
So Please let me know the way Convert DataTable to Generic List or any another way to insert DataTable into Database with single trip without using SqlBulkCopy.