如何使用Visual Studio 2013 Desktop / SqlCe的替代品创建新的SqlCe数据库 [英] How can I create a new SqlCe database with visual studio 2013 Desktop/Alternative to SqlCe

问题描述

大家好，



我试图用MS Visual Studio 2013桌面快递版创建一个sqlce db，但我找不到创建的命令它。

然后我发现它已经被微软弃用了：它有替代品吗？我正在寻找一个不需要服务器才能工作的数据库。 IE：我需要类似Access数据库的文件，但是我想在没有服务器支持的情况下对它执行查询：只是dll或.NET框架。谢谢！



Jymmy097

解决方案

我认为您正在寻找SQL Server Compact。



以下是一些资源：

SQL Server Compact [ ^ ]

微软的嵌入式数据库 - SQL Server Compact - 团队博客 [ ^ ]

Microsoft SQL Server Compact 4.0 [ ^ ]

嗯......有一个Access文件：use ODBC和ACE，您可以直接访问该文件： http://stackoverflow.com/questions/10374808/how-to-connect-to-a-ms -access-file-mdb-using-c [ ^ ]

或者有 SqLite [ ^ ]，其优势在于与Android兼容好。

Hi everybody,

I've tried to create a sqlce db with MS Visual Studio 2013 desktop express edition, but I can't find the command to create it.
Then I've found that it's been deprecated by Microsoft: is there an alternative to it? I'm looking for a db which does not need a server in order to work. IE: I need something like an Access db file, but I want to execute queries on it without the support of a server: just dlls or .NET framework. Thanks!

Jymmy097

解决方案

I think you are looking for SQL Server Compact.

Here are some resources:
SQL Server Compact[^]
Microsoft's Embedded Database - SQL Server Compact - Team Blog[^]
Microsoft SQL Server Compact 4.0[^]

Well...there's an Access file: use ODBC and ACE and you can access the file directly: http://stackoverflow.com/questions/10374808/how-to-connect-to-a-ms-access-file-mdb-using-c[^]
Or there is SqLite[^] which has the advantage of being compatible with Android as well.

这篇关于如何使用Visual Studio 2013 Desktop / SqlCe的替代品创建新的SqlCe数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！