用数据库创建设置 [英] setup creating with database

问题描述

你好，

i需要完整的解决方案和逐步的过程来创建数据库设置..因为当我附加.mdf文件并设置数据源我的应用程序在我的系统中正常工作因为我已经安装了mssql服务器2008但当我在客户端系统中应用相同的东西时，我显示错误，安装sql server时没有安装我在设置创建时设置先决条件..plz帮助我..我无法理解问题。我不想要在我的Windows窗体应用程序的其他系统中安装sql server 2008R2。请帮助我..

hello,
i want complete solution and step wise process for creating setup with database ..because when i attached the .mdf file and set datasource my application works fine in my system beacuse i have installed mssql server 2008 but when i apply same thing in clients system,i show error that sql server is not installed while i set the prerequisite during setup creating..plz help me..i couldn't understand the problem.and i don't want to install sql server 2008R2 in other system for my windows form application.please help me ..

推荐答案

如果您不想将sql server安装到客户端的计算机上，那么您应该使用sqlite等便携式数据库解决方案开发应用程序。它是针对适合您案例的情况开发的数据库系统： https://www.sqlite.org/ [ ^ ]

sqlite也有.net适配器，因此在将代码转换为后者时，代码没有太大变化： http ：//system.data.sqlite.org/index.html/doc/trunk/www/index.wiki [ ^ ]。

如果你坚持使用microsoft sql server，你可以做的最多是准备一个bootstrapper安装程序，它也将安装MS SQL Server Express版本（免费）。但要注意;安装需要一些关于数据库的知识（安装人员将确定sql instace。等。



以下是实现sqlite.net的一些示例：

在C＃应用程序中使用SQLite [ ^ ]

https://code.google.com/p/sqlite-net/wiki/GettingStarted [ ^ ]

http://zetcode.com/db/sqlitecsharp/ [ ^ ]

http://www.dreamincode.net/f orums / topic / 157830-using-sqlite-with-c％23 / [ ^ ]

if you do not want to install sql server to your clients' computers, then you should develop your application with portable database solutions such as sqlite. It is a database system developed for the situations that fit to your case :https://www.sqlite.org/[^]
There are .net adapters for sqlite as well, therefore there is not much of a change in your code while converting it to the latter:http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki[^].
If you insist on microsoft sql server, the most you can do is to prepare a bootstrapper installer that will also install MS SQL Server Express edition (which is free). But be warned; the installation requires some knowledge on databases (person installing will determine sql instace .etc.

Here are some examples on implementing sqlite.net:
Using SQLite in your C# Application[^]
https://code.google.com/p/sqlite-net/wiki/GettingStarted[^]
http://zetcode.com/db/sqlitecsharp/[^]
http://www.dreamincode.net/forums/topic/157830-using-sqlite-with-c%23/[^]

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