SyntaxFix

[c#] how to open *.sdf files?

Try LINQPad, it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0). Best of all it's free!

LINQPad

Steps with version 4.35.1:

  1. click 'Add Connection'

  2. Click Next with 'Build data context automatically' and 'Default(LINQ to SQL)' selected.

  3. Under 'Provider' choose 'SQL CE 4.0'.

  4. Under 'Database' with 'Attach database file' selected, choose 'Browse' to select your .sdf file.

  5. Click 'OK'.

  6. Voila! It should show the tables in .sdf and be able to query it via right clicking the table or writing LINQ code in your favorite .NET language or even SQL. How cool is that?

Examples related to c#

• How can I convert this one line of ActionScript to C#? • Microsoft Advertising SDK doesn't deliverer ads • How to use a global array in C#? • How to correctly write async method? • C# - insert values from file into two arrays • Uploading into folder in FTP? • Are these methods thread safe? • dotnet ef not found in .NET Core 3 • HTTP Error 500.30 - ANCM In-Process Start Failure • Best way to "push" into C# array

Examples related to visual-studio-2008

• Convert Text to Uppercase while typing in Text box • SQL Server r2 installation error .. update Visual Studio 2008 to SP1 • What is and how to fix System.TypeInitializationException error? • Error LNK2019: Unresolved External Symbol in Visual Studio • download and install visual studio 2008 • Git in Visual Studio - add existing project? • Visual Studio can't 'see' my included header files • How to insert Records in Database using C# language? • If statements for Checkboxes • LNK2019: unresolved external symbol _main referenced in function ___tmainCRTStartup

Examples related to sql-server-ce

• How to change column width in DataGridView? • Creating stored procedure with declare and set variables • How to connect to SQL Server from another computer? • how to open *.sdf files? • How do you open an SDF file (SQL Server Compact Edition)? • Connection string with relative path to the database file • How do you create a foreign key relationship in a SQL Server CE (Compact Edition) Database?