Should I have more than 1 database connection?

I have started to make a webapp with asp.net mvc2. I am using the built in users database that is available by default. I want to add tags and more stuff that will need to be stored in the database.

At the moment under data connections, I have ASPNETDB.mdf which has it's tables and all its other information.

If I want to make a tags table, do I create a new data connection or should I add it to that database?

Answers


You could have multiple databases but it would make it difficult to perform queries. A single database could have many tables and it is the recommended approach.


Put your tags table in the same database.

Databases can handle hundreds of tables. Each table can be associated to other tables via key relationships.

Here's a good place to learn about designing databases: http://www.databaseanswers.org/tutorials.htm


Need Your Help

Trouble limiting data set where a piece of data occurs more than once

sql join count subquery having

SELECT FirstName, LastName, [description], ProjectName, StartOnDate, FinishOnDate

How do I implement an operator for a class nested in a generic struct?

generics nested operators swift equality

When I nest a class inside a generic struct and try to implement the equality operator, like this:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.