zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

11 results in tag: sql-server-2008-r2

Database not created by Entity Framework

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?....
asp.net-mvc-3 ef-code-first entity-framework sql-server-2008-r2 visual-studio-2010
asked by mazatsushi

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

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...
.net c# entity-framework navigation-properties sql-server-2008-r2
asked by Nate

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...
.net entity-framework sql-server-2008-r2
asked by Jason Lind

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...
.net entity-framework sql-server-2008-r2 visual-studio
asked by user2283561

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...
c# entity-framework-6 sql sql-server-2008-r2
asked by Peter Smith

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 ...
c# entity-framework-6 sql-server-2008-r2
asked by Andres

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...
asp.net-mvc c# entity-framework sql-server-2008-r2
asked by s.k.paul

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...
c# entity-framework sql-server-2008-r2 winforms
asked by Ronjon

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 ...
c# entity-framework-6 sql-server-2008-r2
asked by Sunil

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...
c# ef-code-first entity-framework sql-server-2008-r2
asked by Ivan-Mark Debono

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...
.net entity-framework-6 sql-server-2008-r2 visual-studio-2012
asked by Puneet Chawla

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!