tags:

views:

55

answers:

1
+1  Q: 

Is it possible to store the ASPNETDB database in a separate project?

I'm building a web application in ASP.NET and I want to separate it into three layers: Presentation, Data and Business.

I want to keep my database in the Data layer but I can't figure out a way to do that with the ASP.NET Memberships database (ASPNETDB.mdf).

Is there any way to tell the site to reference a database file in another project?

A: 

You can't reference the DB in another project to my knowledge. If your DB was in SQL Server instead of in the app_data you could call it from any project....

You can create/recreate the database using the aspnet_regsql.exe if needed.

Since you are wanting to tier you should look at having the presentation tier call the business tier to authenticate which calls the data tier ultimately to check authentication and rights. If you do this then the presentation tier won't need a reference to the DB.

klabranche  2009-12-09 00:03:59
Thanks for the response. I must be doing something wrong then because I tried using a DB in SQL Server and couldn't get the application to use that one. It kept looking for one in App_Data. Is there a connection string I have to enter in web.config or something?
Carl  2009-12-09 00:06:41
add a connection string to the web.config to your DB and point your controls at it. However, if you are trying to tier then in the long run you wouldn't want the presentation tier to reference the DB. But for testing give it a shot.
klabranche  2009-12-09 00:27:03
Thanks again. I got it working with your help.
Carl  2009-12-09 00:35:44
Awesome! Glad to help!
klabranche  2009-12-09 00:40:01

related questions

after running aspnet_regsql.exe , do I have to init the db with data? how?
Not using e-mail address in a custom MembershipProvider?
How to pass the current user to a web control declaratively
How do you rename a Role using Membership in .NET?
What encryption algorithm does the .net membership provider use?
Membership.GetUser() & MARS
Web.config editing for Membership Role Authorization
Globalization of Membership exceptions isn't taking place... What to do?
OpenId development while disconnected from Internet
programmatic login with .net membership provider
Addin extra properties to MembershipProvider
ASP.Net Providers from web server in DMZ
ASP.NET PasswordRecovery Control with Localized content
Examples of asp.net mvc and authentication
ASP.NET Membership for high security scenarios?
ASP.NET Forms Authentication With Only UserName
What to use for membership in ASP.NET
How can I wrap a transaction around Membership.CreateUser?
New site creation and security/authentication,- should I use ASP.net Membership Provider?
ASP.NET WSAT (Website Administration Tool) and Custom Membership Providers
How do you manage asp.net SQL membership roles/users in production?
How to access UserId in ASP.NET Membership without using Membership.GetUser() ?
Can I use OpenId with the ASP MembershipProvider?
How do you pass an authenticaticated session between app domains
Class design decision