单用户数据库选项 [英] Single-user database options

问题描述

我要使用.NET框架和C＃编写Windows应用程序。应用程序将需要存储将被查询，加入和处理的关系数据。

I'm going to be writing a Windows application using the .NET framework and C#. The application will need to store relational data which will be queried, joined and processed.

以前，我使用SQL Server，但这是一个总的overkill的

Previously I've done this using SQL Server, but that is a total overkill for the application I am now making.

在我的应用程序中存储关系数据最简单，最简单的方法是什么？如果我在Mac上，我会使用SQLite。

What's the simplest, easiest way to store relational data in my application? If I was on a Mac, I'd be using SQLite. What's the .NET equivalent?

推荐答案

如果使用VS 2008和.NET 3.5，可以使用 SQL Server Compact Edition 。它不是一个真正的服务器，它运行in-proc与您的应用程序，并提供一个基本的SQL数据库。数据库本身是一个单一的.sdf文件，并与您的应用程序一起部署。 由于它是框架的一部分，它也意味着没有额外的安装。实际上，它不是框架的一部分，但它很容易再分发。我正在使用SQL Server CE的个人项目，我目前正在进行，到目前为止已经出色。

If you are using VS 2008 and .NET 3.5, you can use SQL Server Compact Edition. It's not really a server at all, it runs in-proc with your app and provides a basic SQL database. The databases themselves are a single .sdf file and are deployed with your app. Since it's part of the framework, it also means there's no additional installation. Actually, It's not actually part of the framework, but it's easily redistributable. I'm using SQL Server CE for a personal project I'm currently working on, and it's turned out great so far.

这篇关于单用户数据库选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！