Shawn,

You did not say if this is the only place your connection was failing or not. Not knowing, what I suggest is this: Verify the connection is exactly the same in your business object project app.config file. Then run the Business Layer Generator up to the point where you can click the 'GetData' button. If you get the tables, procedures, etc from the database in the view, then this would confirm if the connection string is valid how it is written for the framework to construct it.

For clarity, the application only uses the connection information in the Web config of the web application. The app config file in the business project is only there for design time activities such as the business layer generator or entity framework. But it is a good place to test the connection as the BLG will use the config connection and parse it the same as the application attempts to do.

>Using security module. I have the following code in the UserLogin.aspx.cs file.
>
>

>public override void HookUserAuthenticated(object userPK)
>{
>    User uo = new User();
>    UserEntity ue = uo.GetUserByUserPK((int)userPK);
>    ue.LastLogin = System.DateTime.Now;
>    ue.FailedTries = 0;
>    mmSaveDataResult result = uo.SaveEntity(ue);
>    base.HookUserAuthenticated(userPK);
>}
>

>
>The User object, User.Partial.cs, has the following code:
>

>public UserEntity GetUserByUserPK(int userPK)
>{
>	IQueryable<UserEntity> query = from user in this.ObjectContext.UserEntities
>								 where user.UserPK == userPK
>								 select user;
>	return this.GetEntity(query);
>}
>

>
>Web.config in web project and App.config in object model project both have the following database settings.
>

>	<databases>
>		<add key="LotteryPool\Connection" value="server=localhost;Integrated Security=SSPI;Initial Catalog=LotteryPool;" />
>		<add key="LotteryPool\DataAccessClass" value="DataAccessSql" />
>		<add key="EntityDataModelContainer\DataAccessClass" value="DataAccessSqlEF" />
>	</databases>
>

>
>When the Linq code is executed in GetUserByUserPK I get the following error:
>

>
>Server Error in '/LotteryPool' Application.
>
>The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid. 
>  Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
>
> Exception Details: System.ArgumentException: The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.
>
>Source Error: 
>
>
>
>Line 49:         /// Initializes a new EntityDataModelContainer object using the connection string found in the 'EntityDataModelContainer' section of the application configuration file.
>Line 50:         /// </summary>
>Line 51:         public EntityDataModelContainer() : base("name=EntityDataModelContainer", "EntityDataModelContainer")
>Line 52:         {
>Line 53:             OnContextCreated();
>  
>
> Source File:  C:\mm.net\Lottery Pool Business Objects\EntityDataModel.cs    Line:  51 
>
>Stack Trace: 
>
>
>
>[ArgumentException: The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid.]
>   System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) +8420466
>   System.Data.EntityClient.EntityConnection..ctor(String connectionString) +43
>   System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) +85
>   System.Data.Objects.ObjectContext..ctor(String connectionString, String defaultContainerName) +16
>   ShawnsLuck.LotteryPool.Business.EntityDataModelContainer..ctor() in C:\mm.net\Lottery Pool Business Objects\EntityDataModel.cs:51
>   ShawnsLuck.LotteryPool.Business.User.CreateObjectContext() in C:\mm.net\Lottery Pool Business Objects\User\User.cs:96
>   OakLeaf.MM.Main.Business.mmBusinessObjectGeneric`1.get_ObjectContextEF() +89
>   ShawnsLuck.LotteryPool.Business.User.get_ObjectContext() in C:\mm.net\Lottery Pool Business Objects\User\User.cs:59
>   ShawnsLuck.LotteryPool.Business.User.GetUserByUserPK(Int32 userPK) in C:\mm.net\Lottery Pool Business Objects\User\User.Partial.cs:34
>   UserLogin.HookUserAuthenticated(Object userPK) in c:\mm.net\LotteryPool\UserLogin.aspx.cs:69
>   OakLeaf.MM.Main.Web.UI.mmBaseUserLogin.Login() +622
>   UserLogin.btnLogin_Click(Object sender, EventArgs e) in c:\mm.net\LotteryPool\UserLogin.aspx.cs:39
>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9653178
>   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
>   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1724
>
>  
>
>
>Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34237  
>