I used to open sdf (sqlCE) files with visual-studio? or sql-server? I really don't remember.
Now I can't open this sdf file. With what program do I need to open it?
C# – how to open *.sdf files
csql-server-cevisual-studio-2008
Related Topic
- C# – How to enumerate an enum
- C# – The located assembly’s manifest definition does not match the assembly reference
- C# – How to save a stream to a file in C#
- Sql – Open SDF database in Visual Studio 2008
- SQL Compact 4.0 can’t open/read sdf file
- C# – Try-catch speeding up the code
- Scala: list.flatten: no implicit argument matching parameter type (Any) = > Iterable[Any] was found
Best Answer
Try LINQPad, it works for SQL Server, MySQL, SQLite and also SDF (SQL CE 4.0). Best of all it's free!
Steps with version 4.35.1:
click 'Add Connection'
Click Next with 'Build data context automatically' and 'Default(LINQ to SQL)' selected.
Under 'Provider' choose 'SQL CE 4.0'.
Under 'Database' with 'Attach database file' selected, choose 'Browse' to select your .sdf file.
Click 'OK'.
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?