Windows应用程序的数据库连接 [英] DataBase Connectivity for windows application

问题描述

我刚刚完成我的大学，然后在一家小公司找到了一份工作，为他们开发应用程序，然后我开发了一个以Access为后端的Windows应用程序，我的老板对此印象深刻，他现在希望将其安装在每一个应用程序中系统和数据库将存储在中央系统中Iam计划现在使用SOL SERVER作为后端

所有系统都在LAN中.通过在该中央系统上创建数据库并将其连接字符串提供给代码，就可以了吗?

由于Iam是这些事物的新手，请抽出时间明确地告诉我.

I had just completed my college and I got a job in a small company to develop an application for them And I had developed an windows application with Access as backend and my boss is impressed and he now want it to be installed in every system and database to be stored in a central system Iam planning to use SOL SERVER as backend now

All systems are in LAN .is it OK Just by creating database on that central system and giving the connection string of it to the code

Please find time to clearly advise me since Iam new in these Things.

推荐答案

是的..您应该将SQL Server放在LAN上的中央位置并进行连接配置文件中的字符串，以便可以根据需要进行更改.
如果可以将应用程序开发为单独的客户端和服务器应用程序，则更好，因为配置文件将仅位于服务器端.

但这全都取决于您的应用程序的大小以及您要花多少时间和精力.

Yes..you should have the SQL server at a central location on LAN and put the connection string in a config file so that it can be changed as and when required.
Better if you can develop the application as separate client and server application because then the config file would be only at server side.

But it all depends how big your application is and how much time and effort you want to spend on it.

这篇关于Windows应用程序的数据库连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！