C# - Best (fastest) way to import data from text file to mdf

I need to import data from text file (not separet开发者_如何学Goed by commas, other way, different characters) to database (for example to mdf). Because datagridview loads data from database faster then from file. What is the best way? Thank you

If using SQL Server (which .mdf suggests you are) you could try bulk inserting:

BULK
INSERT MyTable
FROM 'c:\myfile.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)

Maybe the .NET library FileHelpers can do something for you...