Member Avatar for bdicasa

Hello all,

I have a fairly good grasp on how to design a database (took a couple courses on it) but I'm not sure how to set up a database for use with a website. My plan is to develop the website with ASP.NET and MySQL. The website will have multiple users logged in at once altering the database.

Some questions I have are:

1) How would you configure the MySQL database for use with many users at once.

2) How do you connect the users to the database when they first get to the website? If you use a connection string in the code, wouldn't people be able to get access to the code and find out the name and password for the database, or is the code hidden before deployment of the website?

If you guys could give me any feedback/links about my questions I would greatly appreciate it. Thanks,

Brian

  • 2 Contributors
  • 1 Reply
  • 114 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by dickersonka
Member Avatar for dickersonka

1. The database is already built for transactional processing to handle multiple users. You will most likely have a single 'user account' that you will use to communicate with the database.

2. There are a couple of ways to do this. Normally you can put the connection string in the web.config and encrypt it. Also remember the pages are compiled, so they won't have direct access to your .net code.

Here's a link on how to do it.
http://aspnet.4guysfromrolla.com/articles/021506-1.aspx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.