Hi all,
I have loaded data from excel sheet into a datatable. the datatable holds some 1000s of records. I want to insert those records into db using entity framework with MVC 4 application. As i am new to MVC and EntityFramework, am facing problem to insert this. 
The problem is, it inserts the first data and when the next iteration continuous it shows error on profileid(a Guid filed).
my code:
for (int i = 0; i < importdt.Rows.Count; i++) { string s = importdt.Rows[i]["Date of Birth"].ToString(); if (importdt.Rows[i]["Date of Birth"] != DBNull.Value && importdt.Rows[i]["Date of Birth"].ToString() != "") { DateTime dtime = Convert.ToDateTime(importdt.Rows[i]["Date of Birth"]); ...

Go to the complete details ...