Entity Framework 6 - Knowledge Base (KB)

Entity Framework Not Creating Database

Been playing around with the Code First feature of Entity Framework 4.1 using an ASP.NET MVC 3 project....However the database (SQL Server 2008 R2) does not automatically create the table mapping on application startup. Any ideas on how to make it do so?....

.Skip().Take() on Entity Framework Navigation Properties is executing SELECT * on my SQL Server

I have a method on my generated partial class like this:...var pChildren = this.Children .Skip(skipRelated) .Take(takeRelated) .ToList(); ...When I look at my SQL Server, I can see the generated code is doing a ...SELECT *.* FROM Children... T...

Entity Framework 4 Stored Procedure Call Timing Out

I have a stored procedure imported into EF4, and when I call it with certain parameters after 30 seconds it throws a time out error. In SQL Server profiler I can see the stored procedure call with the proper parameters taking just over 30 seconds, which i...

Error 175: The specified store provider cannot be found in the configuration, or is not valid

I just joined a project and installed Microsoft Visual Studio Professional 2012 Version 11.0.51106.01 and Microsoft SQL Server 2008 R2 on a 64-bit machine. ...Another team member is able to build the solution from his machine, but from my machine I get th...

EF6 stored procedure with no results

My environment is VS 2012, C#, EF6 and SQL Server 2008 R2....I want to execute a stored procedure to delete records with no return value using the pattern:...dataContext.Database.SqlQuery<return type>("name", parameter) ...If there are no results returned...

UpdateException Entity framework bidirectional foreign key

I´m having some trouble with a mapping in entity framework. I have a table Check, that has a foreign key to the table CheckStatusHistory where I store all the check status changes over time. As you can see, Check has a column LastCheckStatusID, that its ...

Database default value is not inserted while create record by entity framework

I have a LoginRecord table in sqlserver 2008 with the following column structure-...LoginId - int, identity UserId - int LoginDateTime- Allow nulls false,default value getdate() ...I am inserting new record by entity framework 6 as below-... db...

System.Data.EntityException: The underlying provider failed on Open

I am building an application which has a database on the server machine and I am using this method for database access: ...public static string GetDefaultConnectionString() { //get my db info from ini file dbinfo DatabaseInfo = new dbinfo(); D...

Table Name Mapping not working in EF 6 when using POCO classes

I am using System.ComponentModel.DataAnnotations.Schema.TableAttribute in class below, so class 'Order_Details' is mapped to table 'Order Details' in Northwind database. ...There is an attribute [Table("Order Details"] just above class definition to map ...

Code First can't enable migrations

I'm trying to enable migrations but it's throwing an exception:...Checking if the context targets an existing database... System.TypeInitializationException: The type initializer for 'System.Data.Entity.Migrations.DbMigrationsConfiguration`1' threw an e...

could not load file or assembly 'microsoft.sqlserver.management.sdk.sfc version=11.0.0.0

I am using Database first approach of Entity framework. When I create new connection in "ADO.NET Entity Data Model" then after adding server name and database name, then it shows me this error - ...Could not load file or assembly 'Microsoft.SqlServer.Man...