I am setting up a site using Entity Data Model, which sets up an entry in the Web.config file something like this: <add name="SomeName" connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="Data Source=sql2k804.discountasp.net;Persist Security Info=True;User ID=USERIDUSERIDUSERID;Password=XXXXX;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient" /></connectionStrings> I am able to retrieve the desired results. Since I also need users to log-in, etc, I am using the database tables, etc... obtained by running aspnet_regsql in my database (Ver for framework 4). Normally what I do is to paste the ConnectionStringName that I get from adding a listbox to an aspx page, for example copy that ConnectionStringName to the Membership, RoleManager, etc ConnectionStringName, and I would be able to access the remote (Discountasp.net) database of users using the Web site administration tool. However, this does not work using the connection string that Data Entities uses. I can naturally just use another connection string - but is that a good way of doing things? Thank you!
