0

I'm developing an application in which i want the software to be executed at any place. So i want the database to be placed in one computer. This is the scenario. All the computers will be networked. Can i do this in c#.net ? Please tell me the procedures. Thank You

3
Contributors
2
Replies
16
Views
4 Years
Discussion Span
Last Post by deceptikon
0

Of course you can. It really isn't a C# issue. The database server should be configured to allow remote access and that's it. There are a lot of tutorials about how to connect to a DB server.

After you decided which one you'll use (MSSQL, MySql, Oracle...) just enable remote access, authentication and access rights and you're good to go.

If you need any specific guidance let me know and I'll help you out.

0

Deploying a database can be tricky as well, even though it's straightforward to require that a database server be present for the application to work. In the past I've used three different deployment methods:

  1. Build the database locally and provide a backup file that can be restored at the deployment site.
  2. Provide scripts that will automatically create tables, indexes, and initial data.
  3. Use the Entity Framework to create and update database schemas.

I overwhelmingly prefer #3, but there's a bit of a learning curve for the Entity Framework. ;)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.