generic database structure help with ASP web forms (microsoft visual web dev)

Question

im trying to create a generic gallery application that uses a database, with the abilitiy to upload images from the website, using microsoft's visual web developer. -- im fairly new with databases and asp.net but am getting the hang of it i think ><

most of the examples i see are one mdf file with several tables. but i want something that i can use repeatedly as a generic template for my databases, as i have several galleries i want to create for my portfolio, or allow others to use it with little difficulty.

What im trying to avoid is having to go through each gallery and create new table adapters and or get/set methods for each new gallery

Should i use a separate mdf file with one table for each gallery? would this allow me to copy/paste each time i want to create a new database and by extension new gallery

thanks for your time

Answer 1

No need to use separate mdf files. You could have only one mdf file (database file).

Why don't you create a gallery table and an image table and connect both with a relationship?

1 Gallery -> has many -> Images - (M X N) relationship

1 image -> belongs to -> 1 Gallery

You could use Microsoft Entity Framework to avoid having to create new table adapters, get/set methods, etc, as it will create everything automatically to you.