如何在不安装任何数据库服务器的情况下在本地运行带有数据库的桌面应用程序? [英] How to run desktop application with database locally without installing any database Server?

问题描述

我想使用Visual Studio 2013和C#创建带有数据库的桌面应用程序，有人可以建议我我用来创建数据库的服务器是什么，以便在不安装任何数据库的情况下在客户端系统中本地运行我的应用程序客户端系统中的服务器(即未安装MsSql服务器，MySql服务器或Acess的服务器)，我是否希望在安装自己的应用程序的exe文件时我的应用程序能够正常工作?

I wanted to create a desktop application with database, am using Visual Studio 2013 and C# , Can anybody suggest me what server I used to create my database, in order to run my application in my client's system locally with out installing any database server in client's system [ie, with out installing MsSql server or MySql server or Acess], I want my app works properly when installing my own application's exe file ?

现在我正在将MSSQL Server与我的应用程序一起使用，是否可以在不安装MSSQL Server的情况下在客户端系统中本地运行此应用程序? [当我安装.Net FrameWork 4.5时，我的应用程序前端可以正常工作，在Sql Server中，我的.mdf数据库需要这样的东西]

And Now am using MSSQL server with my application , Is there any way run this application in client's system locally with out installing MSSQL Server? [my application front end works when I install .Net FrameWork 4.5 , I need something like this for my .mdf databse in Sql Server]

有人说有关SQL Server Compact的信息，但我不知道如何使用它

somebody says about SQL Server Compact ,but i don't know how to use it

推荐答案

您可以使用SQL Server Compact，该SQL Server Compact可以单独安装或作为应用程序的一部分进行部署.

You can use SQL Server Compact, which can either be installed separately or deployed as part of your application.

请参阅此处:如何部署SQL Server Compact Edition 4.0 ?

在这里: https://msdn .microsoft.com/en-gb/library/aa983326(v = vs.110).aspx

您的应用程序中的数据库代码(除了连接字符串外)无需更改，因为您已经在使用某些版本的SQL Server.

Your DB code in your app - apart from your connection string - should not need to change as you're already using some version of SQL Server.

还有一个SQLite，据我所知，它是公认的，但对此我知之甚少. http://www.sqlite.org/

There is also SQLite, which is as far as I know is well regarded, but I know very little about it. http://www.sqlite.org/

希望有帮助！

这篇关于如何在不安装任何数据库服务器的情况下在本地运行带有数据库的桌面应用程序?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！