What is the difference between SqlCeConnection and SqlConnection C#?

Question

I am using Eclipse with its database. I am using SqlCeConnection for connecting however, it doesn't seem to hold the data I don't know why. When I right click on the db and say "show table data", it shows inside null.

I saw SqlConnection. What is the difference between SqlCeConnection and SqlConnection? And do you have any idea why there is no table data in my database?

Answer 1

SqlConnection is for SQL Server Databases

SqlCeConnection is for the Compact Edition