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.

Answers


To create a new sdf File this is a litle example:

// if exists delete the file 

System.IO.File.Delete("Test.sdf");

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


Need Your Help

Access Team Foundation Server (TFS) for non-AD users

tfs active-directory

We have recently installed TFS 2010. Our Active Directory users (i.e. my company's staff) can access it just fine.