I have both SQL Server Compact 3.5 Service Pack 1 and SQL Server Management Studio 2008 (SSMS) installed on my PC. In the past, I was able to select SQL Server Compact Edition from the list of ...

Simple problem. I have an SQL Server database (MyData.mdf) and I want to convert it to a Compact database. (MyData.sdf) Just can t find the proper tool which can do this for me. And I would also be ...

I am pulling the hair out of my head trying to figure this one out. I can t make Parameterized queries to work in VB.Net, when I am using parameters. From what I have found, using a parameter in a ...

I just can t open this connection if the file extension is different to .sdf. Is there a workaround? Please do not suggest temporarily changing the file extension. Thank you

I m learing LINQ-to-SQL right now and i have wrote a simple application that define SQL data: [Table( Name = "items" )] public class Item { [ Column( IsPrimaryKey = true, IsDbGenerated = ...

I have a DataGridView that shows list of records and when I hit a insert button, a form should add a new record, edit its values and save it. I have a BindingSource bound to a DataGridView. I pass is ...

I am in the process of developing a desktop application that needs a database. The application is currently targeted to SQL Express 2005 and works wonderfully. However, I m not crazy about having ...

I have this question in which I have a SQL Server Compact Edition database for a desktop application. I am completely new to Sql Server Compact Edition. The question is, does the data inserted in the ...