应用程序在我的客户机上运行的要求，在C＃平台4.0上开发（Windows应用程序） [英] Requirements for an application to run on my client's machine, developed on platform 4.0 in C# (Windows application)

问题描述

嗨朋友...........



i想知道，



1。应用程序在我的客户机上运行所需的要求，在C＃中使用平台4.0开发并使用的数据库是



Sql Server Management Studio 2008.



2.如何保护我的数据库。所以没有人可以错过使用。



3.如何在我的应用程序的设置中添加所有这些要求



申请类型（Windows应用程序）



请帮忙......

Hi Friends...........

i want to know ,

1. Requirements needed by an application to run on my client''s machine, developed on platform 4.0 in C# and database used is

Sql Server Management Studio 2008.

2. How can I protect my database. So that no one can miss use.

3. How can I add all these requirements in my application''s setup

Application Type (Windows Application)

Please help......

推荐答案

您需要.NET和SQL Server。



您无法阻止本地拥有数据库的人访问它。也不应该，这是他们的数据。你可以用密码保护它，但是它们有数据，它们可以进入。



你可以创建一个安装.NET的安装程序，但SQL Server是一个单独的exe，并获得许可。如果您使用免费的，您仍然需要编写一个安装该程序的程序，然后运行您的MSI

You need .NET and SQL Server.

You can not stop people who have a database locally from accessing it. Nor should it, it''s THEIR data. You can password protect it, but they have the data, they can get in.

You can create an installer that installs .NET but SQL Server is a seperate exe, and is licensed. If you use the free one, you still need to write a program that installs that, and then runs your MSI

如果这是一个独立的应用程序，您可以将数据库放在应用程序并确保您的规则在传递数据时是稳定的，然后唯一的访问是该应用程序。



如果这是公共样式应用程序，那么你可以硬编码应用程序内部的连接字符串，因此只有应用程序可以与数据库通信。



除此之外，还需要知道是否存在需要解决的特定风险提供所需的安全性。



与数据库通信时要注意的事项是确保脚本由代码和sql管理，以便注入赢得'不会发生。



一些最好的方法是通过存储过程，任何时候你有一个文本字段传入数据，确保你作为数据处理而不是一个函数，所以用户可以通过SQL传递一个语句进行处理（如果有意义的话）。



希望有所帮助。

If that is a stand alone application, you can have the database be housed in the application and secure that your rules when passing data into is stable then the only access is that application.

If that is public style application, then you can hard code the connection strings inside the application so only the application can communicate to the database.

Outside of that, would need to know if there are specific risks that need to be address to provide the needed security is in place.

Things to watch for when your communicating to the database is to insure your scripts are managed by the code and sql so injection won''t occur.

Some of the best ways are through stored procedures and anytime you have a text field passing in data, make sure you are treating as data and not a function so users can pass through a statement to process by SQL (if that makes sense).

Hope that helps.

这篇关于应用程序在我的客户机上运行的要求，在C＃平台4.0上开发（Windows应用程序）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！