Clash Royale CLAN TAG#URR8PPP

Unknown Connection String Executing

I've clearly stated what connection string I need my MVC application to use in Web Config file:

<?xml version="1.0" encoding="utf-8"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=301880
-->
<configuration>
<configSections>
<!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
<section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
</configSections>
<connectionStrings>
<add name="OnlineStoreDB" connectionString="Data Source=(localdb)MSSQLLocalDB; Initial Catalog=OnlineStoreDB; Integrated Security=True; MultipleActiveResultSets=True; AttachDbFilename=|DataDirectory|OnlineStoreDB.mdf" providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<add key="webpages:Version" value="3.0.0.0" />
<add key="webpages:Enabled" value="false" />
<add key="ClientValidationEnabled" value="true" />
<add key="UnobtrusiveJavaScriptEnabled" value="true" />
</appSettings>
<system.web>
<authentication mode="None" />
<compilation debug="true" targetFramework="4.5.2" />
<httpRuntime targetFramework="4.5.2" />
</system.web>
<system.webServer>
<modules>
<remove name="FormsAuthentication" />
</modules>
</system.webServer>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin.Security" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin.Security.OAuth" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin.Security.Cookies" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Microsoft.Owin" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-3.0.1.0" newVersion="3.0.1.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" culture="neutral" publicKeyToken="30ad4fe6b2a6aeed" />
<bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Optimization" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="1.1.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="WebGrease" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="0.0.0.0-1.5.2.14234" newVersion="1.5.2.14234" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Helpers" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Mvc" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-5.2.3.0" newVersion="5.2.3.0" />
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.WebPages" publicKeyToken="31bf3856ad364e35" />
<bindingRedirect oldVersion="1.0.0.0-3.0.0.0" newVersion="3.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
<parameters>
<parameter value="mssqllocaldb" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
</providers>
</entityFramework>
<system.codedom>
<compilers>
<compiler language="c#;cs;csharp" extension=".cs" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:6 /nowarn:1659;1699;1701" />
<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" type="Microsoft.CodeDom.Providers.DotNetCompilerPlatform.VBCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" warningLevel="4" compilerOptions="/langversion:14 /nowarn:41008 /define:_MYTYPE=&quot;Web&quot; /optionInfer+" />
</compilers>
</system.codedom>
</configuration>


But when I'm running this app, following runtime error is occuring:

Cannot attach the file 'D:Visual Studio ProjectsOnlineStoreOnlineStoreApp_DataDefaultConnection.mdf' as database 'DefaultConnection'.

Cannot attach the file 'D:Visual Studio ProjectsOnlineStoreOnlineStoreApp_DataDefaultConnection.mdf' as database 'DefaultConnection'.

I've looked very hard to find DefaultConnection everywhere in my app, but nothing to avail.

DefaultConnection

Can anyone please help me find out what's goin on in the background.

Thanks in advance.

Update

I found this following code in file IdentityModels.cs which has this name DefaultConnection in it. Not sure what exactly its doing:

IdentityModels.cs

DefaultConnection

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>

public ApplicationDbContext()
: base("DefaultConnection", throwIfV1Schema: false)



public static ApplicationDbContext Create()

return new ApplicationDbContext();


public System.Data.Entity.DbSet<OnlineStore.Models.Item> Items get; set;



Context file code:

Context

using System.Data.Entity;
using System.Data.Entity.ModelConfiguration.Conventions;
using Microsoft.AspNet.Identity.EntityFramework;
using OnlineStore.Models.MvcMusicStore.Models;

namespace OnlineStore.Models

public class OnlineStoreDB : IdentityDbContext

public OnlineStoreDB()
: base("OnlineStoreDB")

Configuration.LazyLoadingEnabled = false;
Configuration.ProxyCreationEnabled = false;

public DbSet<Item> Items get; set;
public DbSet<Category> Categories get; set;
public DbSet<Brand> Brands get; set;
public DbSet<Cart> Carts get; set;
public DbSet<Order> Orders get; set;
public DbSet<OrderDetail> OrderDetails get; set;
public System.Data.Entity.DbSet<OnlineStore.ViewModels.ShoppingCartViewModel> ShoppingCartViewModels get; set;
protected override void OnModelCreating(DbModelBuilder modelBuilder)

base.OnModelCreating(modelBuilder);
modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>();





Please note that I'm deriving Context class (OnlineStoreDB) from IdentityDBContext instead of DBContext because I need to use IdentityRoles in my app.

Context

OnlineStoreDB

IdentityDBContext

DBContext

IdentityRoles

DefaultConnection

1 Answer
1

You need to change DefaultConnection in ApplicationDbContext constructor to your own connection key (i.e. OnlineStoreDB) like this:

DefaultConnection

ApplicationDbContext

OnlineStoreDB

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>

public ApplicationDbContext()
: base("OnlineStoreDB", throwIfV1Schema: false)



public static ApplicationDbContext Create()

return new ApplicationDbContext();


public System.Data.Entity.DbSet<OnlineStore.Models.Item> Items get; set;



Note that ApplicationDbContext constructor expects loading database definitions from provided connection string from its IdentityDbContext constructor, and since no connection string (and database file) associated with connection which has key DefaultConnection the error was thrown.

ApplicationDbContext

IdentityDbContext

DefaultConnection

Additional note:

Sounds like your current connection string should be modified to this one:

<add name="OnlineStoreDB" connectionString="Data Source=(localdb)MSSQLLocalDB;
Initial Catalog=OnlineStoreDB;Integrated Security=True;
MultipleActiveResultSets=True; AttachDbFilename=|DataDirectory|OnlineStoreDB.mdf"
providerName="System.Data.SqlClient" />


OnlineStoreDB

dbo.__MigrationHistory

Enable-Migration

Add-Migration

Update-Database

OnlineStoreDB.mdf

OnlineStoreDB.mdf

[]

OnModelCreating

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.