Importing CSV to SQL Server CE SDF
I am trying to import a csv file into an SQL sever CE sdf database in a c# mvc3 web app. I understand that I need to read the csv file first and then transfer the file line by line into the sql database. I am very new to programming and need some guidence on how to do this.
I have heard Sql Compact Bulk Copy is the way to go, but I do not understand how to get the CSV file so it can be used by this. If anyone can shed some light on this I would be very greatful.
I hope this makes sense.
To create a new sdf File this is a litle example:
// if exists delete the file
string cnn = "Data Source = 'TestDB.sdf'; LCID=1033; Password = <ThePassword>;"; SqlCeEngine ceEngine = new SqlCeEngine(cnn); ceenngine.CreateDatabase();`
If you need to know more details you can read this MSDN(Create a Database by Using the Engine Object) http://msdn.microsoft.com/en-us/library/ms171966.aspx