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

Entity Framework Core - Knowledge Base (KB)

451 results in tag: sql-server

Entity Framework: The provider did not return a providermanifest instance

Entity Framework 6.0.1 my App.config:...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 --> <section name="e...
c# ef-code-first entity-framework entity-framework-6 sql-server
asked by Temaska

Mapping composite keys using EF code first

Sql server table:...SomeId PK varchar(50) not null OtherId PK int not null ...How should I map this in EF 6 code first?...public class MyTable { [Key] public string SomeId { get; set; } [Key] public int OtherId { get; set; } } ...I've se...
c# entity-framework entity-framework-6 sql-server
asked by loyalflow

How can I parse a string into a UNIQUEIDENTIFIER?

I'm writing an Entity Framework LINQ query in which I want to parse a string into a UNIQUEIDENTIFIER (aka GUID) as part of the ...WHERE... clause:...public IEnumerable<User> Find(Guid guid) { return dbContext .Users .Where(user => Guid...
.net entity-framework entity-framework-6 guid sql-server
asked by Sam

How to integrate ASP.NET Identity tables in an existing database

Using Asp.net 4.5 and VS 2013, I would like to know how to integrate Asp.Net Identity Tables with an existing database....So basically I would like to have db tables for Identity and my own tables in the same db....I know Asp.Net Identity use Code First a...
asp.net-mvc entity-framework entity-framework-6 sql-server
asked by GibboK

How to test if database is hosted on SQL Azure?

Is it possible to test whether a database is hosted on SQL Azure? I am looking at SqlAzureExecutionStrategy for EF6 and only want to apply if the database is actually SQL Azure database....Currently I am testing if App is running within Azure. However we ...
azure-sql-database entity-framework entity-framework-6 sql-server
asked by GraemeMiller

Manually add a migration?

I've been using Entity framework code first in a project and all the tables have been created /modified a while ago. Now I need to add an unique constraint to a table. I want to create a migration which will have the following row in the ...Up()... method...
c# ef-code-first entity-framework entity-framework-6 sql-server
asked by ca9163d9

Entity Framework 6 transaction rollback

With EF6 you have a new transaction which can be used like:...using (var context = new PostEntityContainer()) { using (var dbcxtransaction = context.Database.BeginTransaction()) { try { ...
c# entity-framework entity-framework-6 sql-server transactions
asked by The Cookies Dog

How to set the isolation level for Entity Framework CodeFirst Migrations

If you run an entity framework migration (either automatic or explicit) against tables published for SQL Server replication you get the following error: ...You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels....
c# ef-migrations entity-framework entity-framework-6 sql-server
asked by Paul-Jan

EF6 ignoring [Table] and [Column] in entity classes

I used EF6 Database First tools to generate C# classes for 2 tables from my database, then (as advised in the blog post that helped me through the steps to do that) copied the resulting .cs files into a new project. I made a few edits to the classes to su...
c# ef-code-first entity-framework entity-framework-6 sql-server
asked by J.Merrill

Multi-tenancy in EF6 with multiple schemas having the same tables

In our system it has become required to provide a multi-tenant solution, where each tenant has the same data structure....During investigation I came across an article discussing multi-tenancy with EF4.1....http://romiller.com/2011/05/23/ef-4-1-multi-tena...
.net c# entity-framework entity-framework-6 sql-server
asked by Dark Templar

Use strong spatial types option in model designer locked?

I'm working on a model first EF6 model in model first approach....EF exposes more than DBGeometry and DBGeography and allows me to select specific subtypes when designing the model (like GeographyPoint)....However my generated classes are still simply DBG...
.net-4.5 ef-model-first entity-framework entity-framework-6 sql-server
asked by Ronan Thibaudau

Streaming varbinary(max) data using Entity Framework 6

I have a SQL Server 2012 table that contains file records. Each record has a ...varbinary(max)... column ...BlobData... that represents the data stored in the file – data size can be over 1 GB and cannot fit into RAM, so I don't want it backed by a byte...
.net c# entity-framework entity-framework-6 sql-server
asked by w128

Entity Framework 6.1 : The given key was not present in the dictionary

I have a table with some relations, the program works fine until I add a new relation between this table and ...customer... table, the ddl for ...PermissionCode... Table (first table) is as below:...CREATE TABLE [dbo].[PermissionCode] ( [Id] int NOT NULL ...
asp.net-mvc ef-database-first entity-framework entity-framework-6 sql-server
asked by Mesut Talebi2

How do I do an EF Database.ExecuteSQLCommand async?

Here's the code that I am using:... public async Task<IHttpActionResult> NewTopicTests([FromBody] NewTopicTestsDTO testSpec) { var sql = @"dbo.sp_new_topic_tests @Chunk"; SqlParameter[] parameters = new SqlParameter[] ...
asp.net asp.net-web-api entity-framework entity-framework-6 sql-server
asked by Samantha J T Star

How can I change data type of a column in SQL Server?

I am using SQL Server 2008 R2....I want to change the data type of a column (...Size...) from ...decimal... to ...int.... First, I used designer of SQL Server but SQL Server did not allow me to do it. Please attention to the picture....Then I decided to w...
database-migration entity-framework entity-framework-6 sql-server
asked by Said Roohullah Allem

Entity Framework database first aggregate column with eager loading

I'm using Entity Framework 6.x database first and a SQL Azure database....I have a database table of ...Studies... and a separate table of ...Respondents.... In my EF designer, I have a Studies entity and Respondents entity and the Studies Entity has a N...
c# entity-framework entity-framework-6 sql-server
asked by Dave Weisberg

Can I use UseCSharpNullComparisonBehavior for a single query?

I have a query that used to be a stored procedure and was converted to an EF query. It is timing out now. Using SQL Profiler, I can see the only difference in the SQL generated is the new behavior where EF turns ...entity.Property == value... into ...(ent...
c# entity-framework entity-framework-6 sql-server
asked by adam0101

Entity Framework 6 - Timing queries

I am using Entity Framework 6 and it's awesome database interceptor features to log queries which are being sent from application the database. However, I am struggling to time those queries, I have a long running query which returns hundred of thousands ...
c# entity-framework entity-framework-6 sql-server
asked by Yogesh

ProviderManifestToken 2008 or 2012

The application:....NET 4.5 C#...Uses EF6 with database first approach...Supports SQL Server 2008R2, 2012 and 2014...This question is regarding the ...ProviderManifestToken... attribute of the auto-generated edmx file. ...Depending on which version of the...
.net entity-framework entity-framework-6 sql-server
asked by Sumit Garg

EF6 Does not generate foreign key association from database

PROBLEM:...I am trying to create a EF6 model using the database first approach. Simply speaking, I have 2 tables ...tblUser... and ...tblMilkMan... which have a foreign key relationship on the ...UserID... column. But when I create a new EDMX diagram and ...
c# entity-framework entity-framework-6 foreign-key-relationship sql-server
asked by Sajjan Sarkar

Page 1 of 23
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

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
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!