c# - Cannot find my Entity Framework database -


i little confused on code first entity framework database.

i created new dbcontext , class storing in context, this:

namespace myproject.subproject.something {     public class myitem     {         public string 1 { get; set; }         public string 2 { get; set; }         [key]         public string 3 { get; set; }         public string 4 { get; set; }     }      public class myappdata : dbcontext     {         public dbset<myitem> myitems { get; set; }     } } 

i know it's working since can without failure:

var db = new myappdata(); myitem = new myitem(); // ... fill in item db.myitems.add(i); db.savechanges(); 

additionally, if restart application find db.myitems.count() reflect items in fact persistently stored somewhere.

i'm assuming stored in localdb since set no sql server database. want able see table in localdb somewhere, can't seem find it.

if go data sources -> add new data source -> database -> data set -> new connection -> microsoft sql server , put in (localdb)v11.0 server name , dropdown list of databases, not see myappdata or myitems listed.

edit: see in app.config <defaultconnectionfactory type="system.data.entity.infrastructure.localdbconnectionfactory, entityframework">


edit 2: full app.config

<?xml version="1.0" encoding="utf-8"?> <configuration>   <configsections>     <!-- 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=xxxxxxx" requirepermission="false" />   </configsections>   <startup>     <supportedruntime version="v4.0" sku=".netframework,version=v4.5" />   </startup>   <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> </configuration> 

you need set database server (localdb)\mssqllocaldb. change made ef 6.1.1 onwards. mssqllocaldb mentioned in parameter. more details on change can found here https://entityframework.codeplex.com/workitem/2246

mssqllocaldb default instance name on sql server 2014 whereas v11.0 default instance name on sql server 2012


Comments

Popular posts from this blog

shopping cart - Page redirect not working PHP -

php - How to modify a menu to show sub-menus -

python - Installing PyDev in eclipse is failed -