Developing a data-oriented, multi-user application window using Visual Studio 2010

Question

So, after I have been programming for about 3 months, I found myself in a situation where I would like to try to create an application for database windows that can be used by several users on my office network.

What I'm trying to do is create a simple property database for my small company, which can be accessed by half of a dozen employees.

The problem I am facing is that I am not sure that I am building the Windows application correctly to share one database on a server on our network. I created what I consider to be one user application with Express DB 2008. However, I am not sure if I can take this program and transfer it to a multi-user program.

I'm trying to find a quick guide, perhaps some tips and tricks on how to initially set up a project to properly deploy the project as a multi-user application. However, I could not find anything relevant.

I really have no problem re-creating the project from start to finish, as this is good practice, and I am sure that in many places I have inefficient code. I just need to start something.

All our machines use WinXP, and I am sure that we have SBS 08.

Noob thanks will be given to those who help and thank you for your time.

Edit: I am using Linq-to-Entities if that means anything.

Answer 1

How to make your application the way it is, and put the database in a central place.

Then, set the connection string correctly to point the application to the central database.

Like this: suppose you installed the sql server on a machine named mypc, then the connection string will look like this: "data source = mypc; start directory = mydb; integrated security = true" what does this mean

mydb mypc. . . SQL- . sql express . modyfy conn string to " = mypc\sqlexpress; = mydb; = "

Answer 2

, . , . .

: http://www.connectionstrings.com/

, (... , concurrency, ect ... , 2 ...)

;)

Answer 3

- ( ) , Windows , .

, - , app.config, .