c# database architecture

Question

I am planning to build an equipment maintenance application. I am going to use C# and WPF with Access or SQL database(s). This single application is going to handle many projects (facilities).

My question is: What is the best approach...

create separate databases for each project
have one (much more complex) database which will handle all facilities

I would use one database, and I don't expect that to be "much more complex" just because of that one additional requirement..... — marc_s
– marc_s, Commented Jan 28, 2011 at 14:50
There isn't enough detail to answer this question. How many concurrent users will the application have? Will you need to report on all projects in one place? Why do you think you need to use multiple databases? — Oded
– Oded, Commented Jan 28, 2011 at 14:50
If you don't need to share, combine or report on data between facilities, then I would tend toward separate database and SQLLite. If you want to combine the data in any way, then a SQL server of some type. — kenny
– kenny, Commented Jan 28, 2011 at 14:52

Gabriel Magana · Accepted Answer · 2011-01-28 15:02:47Z

3

Unless there is a specific requirement for it to be separate databases, do not separate them. In the end it will turn out to be much more maintenance effort to have all these databases (how do you know each one is backed up and restorable? What happens when the structure changes, how do you apply the changes to each database in a safe way? etc)

What seems complex right now (having a single database) will be much simpler in the long run.

answered Jan 28, 2011 at 15:02

Gabriel Magana

4,56627 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jim Over a year ago

Do you have any tutorial, example or pattern how to build this database/app. Not asking about this specific task rather a general approach?

Community · Accepted Answer · 2017-05-23 11:50:12Z

0

Using single database for the equipment maintenance application would be better. Have a look on below link too as similar scenario have discussed before: Any gain on performance when using single vs multiple databases?

Feel free to ask further questions if arises. Thanks.

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Jul 5, 2013 at 6:45

Praveen Prajapati

9891 gold badge17 silver badges22 bronze badges

Collectives™ on Stack Overflow

c# database architecture

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related