数据存储选项
我已经构建了一个随应用程序一起提供的专用服务器应用程序。截至目前，它以二进制文件和 XML 文件的混合形式存储数据，但我发现，由于存储所需的数据量不断增长，这种方式变得过于混乱且缓慢。
那么，我可以选择哪些选项来以更易于搜索/编辑的格式存储数据。能够对数据进行 SQL 查询会更好，但我不想强迫用户安装数据库系统。
I've built a dedicated server applications that ships with the application. As of now it is storing data in a mix of binary- and XML files, but I've found that this gets way too messy and slow now that the amount of data required to store grows continuously.
So what are my options for storing data in a format that is easier search/editable. Being able to do SQL queries on the data would be preferable, but I don't want to force the users into installing a database system.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我相信您正在寻找SQL Server Compact。
您可以轻松地将所有支持文件实施到您的安装中，它是免费的，在 .NET 中有很好的支持，并且占用空间很小。它是您现在使用的一个很好的替代品。当然，也有一些缺点，例如缺乏存储过程支持以及尝试使用 LINQ 时需要一些额外的工作，但这些对您来说不应该是大问题。
您的其他选择类似于 SQLite。 SQLite 快速且可移植（Google Chrome 使用它），并且可在 .NET 中使用，但对日期/时间操作的支持很差，并且存在许多其他类似的不便。
I believe you are looking for SQL Server Compact.
You can easily implement all of the support files into your installation, it's free, has great support in .NET, and has a small footprint. It's a great alternative to what you are using now. Of course, there are a few downsides, such as lack of stored procedure support and a little bit of extra work while trying to use LINQ, but those shouldn't be big problems for you.
Your other alternative is something like SQLite. SQLite is fast and portable (Google Chrome uses it), and usable in .NET, but has poor support for date/time manipulation, and a slew of other similar inconveniences.