All geek questions in one place

Access-like editor for SQL Compact Edition

I would like to find the best SQL Server Compact flat database editor. In fact, we want to click on arbitrary flat typed datasets of less than 4 GB each and have good editing experience to manage this data. Access is not the first thing that comes to mind, but I'm looking for a more "de facto" approach, rather than a "path that traveled less."

I am looking for something that I can point to an SDF file and have fairly reliable editing tools for typed datasets, including ntext multi-line fields.

this one seems pretty close, but it’s not quite what I am looking for (if I went along this route, I would look for something implemented in WPF) and I imagine somewhere that this is a problem.

+3
source share
2 answers

I am currently using SQL Compact Query Analyzer

http://sqlcequery.codeplex.com/

Not sure if it is good for large datasets, but it has at least basic queries / editing, and it is a good replacement for SQL Server Management Studio, which does not support Sql compact 4.0.

The above code is open source, so it can be the starting point for a more complex application that you can create.

+1
source

You can also use LinqPad ( https://www.linqpad.net ). You can run both Linq queries and standard SQL queries in SQL Server Compact ( *.sdf) database files .

0

Source: https://habr.com/ru/post/1768574/

More articles:


All Articles