web applications - ASP.NET EF5 code-first not creating SQL Server CE database -

-

i searched far , wide, went through tutorials , tips, wont work!

ef 5 code-first not generating sql server ce 4 database file.

i have asp.net web application , want generate database using code-first approach.

here model classes:

    public class class     {         [key]         public int id { get; set; }         public bool islecture { get; set; }          public int courseid { get; set; }         public virtual course course { get; set; }         public int teacherid { get; set; }         public virtual teacher teacher { get; set; }     }      public class course     {         [key]         public int id { get; set; }         public string name { get; set; }         public int semester { get; set; }     }      public class teacher     {         public int id { get; set; }         public string name { get; set; }         public string lastname { get; set; }     }

here context:

    public class mycontext : dbcontext     {         public dbset<class> classes { get; set; }         public dbset<teacher> teachers { get; set; }         public dbset<course> courses { get; set; }     }

here connection string in web.config:

    <add name="mycontext"           connectionstring="data source=|datadirectory|\mycontext.sdf"          providername="system.data.sqlserverce.4.0" />

this in global.asax.cs:

    protected void application_start()     {         database.setinitializer<mycontext>             (new dropcreatedatabaseifmodelchanges<mycontext>());          ...     }

i've tried w/ , w/o these lines in global.asax.cs , w/ , w/o connection string.

the application loads , works, database file isn't created. tried creating .sdf file myself, populated ef code-first, remains empty.

the project asp.net mvc 4 made hottowel template, if means anything, , i'm using visual studio 2012.

solved:

needed code in global.asax.cs:

    mycontext context = new mycontext();     context.database.initialize(true);

this works me - need connection factory... 

<configsections>... </configsections> <entityframework>     <defaultconnectionfactory          type="system.data.entity.infrastructure.sqlceconnectionfactory, entityframework">         <parameters>             <parameter value="system.data.sqlserverce.4.0" />         </parameters>     </defaultconnectionfactory> </entityframework>

Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

css - invalid property value for padding -

-
i getting invalid property value padding , don't know why. code written in ruby btw. when check browser has right value pixels, crossed out w line , isn't reading attribute. in advance. <% mywaldo = mapping::mywaldos.sample %> <!doctype html> <html> <head> <title>sinatra single-serve</title> <link href="css/bootstrap.css" rel="stylesheet" type="text/css"/> <style> div { width: 1024px; height: 768px; background-image: url("img/waldos/<%= mywaldo[0]%>") ; } #waldo { position:absolute; top: <%= mywaldo[2]%>; left: <%= mywaldo[1]%>; padding: <%= mywaldo[3]%>, <%= mywaldo[4]%>; } </style> </head> <body> <div> <a id="waldo" href="">aa</a> </div> <%= yield %> </body> ...
Read more