wpadcamp1I try to look for some tools to open a sample database attached with application development sample on the net. I have found that the file has an extension.sdf. It make me strange at first because I do not really know what that file extension would be.

1. Microsoft Sql Server Compact 3.5 Sp1 Query Tools English Download
2. Free Download Microsoft Sql Server Compact 3.5 Sp1
3. Sql Server Compact Edition 3.5

Would that possible a database file or just a flat file? It is exactly as what I thought, it is an extension file for an SQL Server Compact Edition. A sample of (SQL Compact Edition 3.5) file can be download from my backup.Microsoft SQL Server Compact ( SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops. Prior to the introduction of the desktop platform, it was known as SQL Server for Windows CE and SQL Server Mobile EditionThis guide is provide the step on how to open the file content using either extension is Visual Studio or standalone application call LINQPad. I made these to share with you all in case that you need to see the data, schema of that SQL Compact Edition look like.Currently there are two possibility to open.sdf (SQL Compact Edition):. Using Visual Studio toolboxIt is support in Visual Studio 2015, 2013, 2012, 2010.

You need to download from Microsoft or from my and install it into your PC. Where to get LINQPad?The program is base on.Net Framework, so before being able to use the stand alone program, your PC need to have.Net Framework prior install.Up-to-Date, there have two version available where you can download it from their official website at or with my personal backup and.

How to install?. By clicking on the file you just download. Choose where your files will be installed to. I think we just leave it to their default setting.

Microsoft Sql Server Compact 3.5 Sp1 Query Tools English Download

Associate file extension to be able to open with LINQPad. Finally stage is to check “Launch LINQPad”, follow by clicking Finich Button.

How to open.sdf file?Note:If you got error while linking to sample database similar like 'the required DbProvider registration is not present' or 'Unable to find Requested.Net Framework Data Provider. It may not install'.

Free Download Microsoft Sql Server Compact 3.5 Sp1

You would need to download and install in your PC. Click on Add Connection. Then choose Default(LINQ to SQL). Choose provider in our case is SQL CE 3.5, then click on Browse to search for the sample file that I had mention above.

Sql Server Compact Edition 3.5

You can click on Test button to see whether your setting are correctly works. In any case, alert message will be shown. Once the test is running smooth, just click on button Ok to go through database exploration. Finally, we can explore all their tablesNow, you see it is not complicate if we knew the tools. If you have trouble on following my guideline, please fill free to contact me.