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...
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...
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...
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...
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 ...
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...
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 { ...
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....
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...
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...
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...
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...
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 ...
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[] ...
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...
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...
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...
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 ...
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...
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 ...
asked by Sajjan Sarkar