Entity Framework Core Tutorial - Knowledge Base (KB)
174 results for: in tag: sql-server
Is there an Entity Framework 7 Database-First POCO Generator?
I've been playing around with Entity Framework 7 and ASP.NET 5 for a new project I'm working on, but I've hit a roadblock. The team I'm working on uses a DBA-first approach to development; i.e. the database is designed by DBA's and then the developers alt...
asked by Ron Penton
Entity Framework 7 migration: how to get a varchar column with a length greater than 1?
I have the following:...[Table("Countries")] public class Country { public int CountryId { get; set; } [MaxLength(255), Required] public string CountryName { get; set; } [Column(TypeName = "varchar")] public string CountryCode { get;...
asked by Rich76
Database-first EF7-beta7 dnx ef dbcontext scaffold command fails
In an asp.net 5 beta 7 project no matter how the command is written I get an unrecognized argument trying to scaffold the dbcontext from an existing db:...C:\Dev\Project>dnx ef dbcontext scaffold provider EntityFramework.SqlServer connection "Data So...
asked by Alek
Entity Framework 7 fails to insert datetime
I'm using EntityFramework 7, beta7 and have the following entity:...C#...public class Log { [Column(TypeName ="datetime")] public DateTime Date { get; set; } ... } ...SQL...CREATE TABLE [dbo].[Logs] ( [Date] [datetime] NOT NULL, ... ) ...
asked by Stafford Williams
Update to EF 7.0.0-rc1-final broke SQL DbContextOptionsBuilder UseSqlServer
I just updated my nuget package to EF 7.0.0-rc1-final from a previous EF 7 version it has broke my sql connection string code. ...using System.Collections.Generic; using ComicEndpoints.Models; using System.Threading.Tasks; using Microsoft.Data.Entity; pro...
asked by AndrewBrntt
How to scaffold DbContext with plural DbSet property names in Entity Framework Core?
I use ...Scaffold-DbContext... command in ...Package Manager Console... to create and re-create context and entities for an existed SQL Server database:...Scaffold-DbContext -provider EntityFramework.MicrosoftSqlServer -connection "my connection string" ....
asked by Ilya Chumakov
How can I call a SQL Stored Procedure using EntityFramework 7 and Asp.Net 5
For last couple of days I am searching for some tutorials about how to call a ...Stored Procedure... from inside a ...Web API... controller method using ...EntityFramework 7.......All tutorials I came through are showing it the other way round, i.e. ...Co...
asked by Subrata Sarkar
EF 7 : INSERT statement conflicted with the FOREIGN KEY SAME TABLE
I have an exception when I call SaveChangesAsync. My architecture is really simple, i have a Category class, wich contains...public class Category { public Guid ID {get; set;} public Guid? ParentId {get; set;} public Category Parent {get; set;} [..
asked by cdie
MS SQL Auto Increment non Identity Column
I have a table with an auto incrementing identity/primary key column called ID....CREATE TABLE Table1( [ID] [bigint] IDENTITY(1,1) NOT NULL, [TextContent] [nvarchar](450) NOT NULL, [Version] [bigint] NOT NULL) ...When I UPDATE [TextContent], I'd like [...
asked by Simon Ordo
Updating foreign key in Entity Framework 7
I am trying to update a foreign key using Entity Framework 7. But it is giving error: The property 'Y' could not be found in object 'X'. I have tried many different solution but still not working. The sample code:...class X { property Y {get; set;} -> p...
asked by Jash
Mapping One-to-Zero-or-One with EF7
I am currently in the process of cleaning up a fairly large database. Part of the database has a relationship which is a one-to-zero-or-one mapping. Specifically:...User -> UserSettings ...Not all users will have user settings, but a user setting cannot e...
asked by JasCav
How to offload geography operation to SQL Server in Entity Framework Core 1.0
How to consume geography data stored in SQL Server using Entity Framework Core if geography data type is not yet supported and stored procedures too?
asked by Andrii
Entity Framework 7 Stored Procedure Result to Model
I have a Model which is mapped to the database via EF7. All properties are identical to the mapped columns of the table....Now I have a Stored Procedure, which returns some Joined Columns but the basis is still the mapped Model....Here is my model(Entity)...
asked by nicn
EF 7/Core: Getting count of records in child table
I tried asking posing this question/problem in the issues section of the EF Core GitHub but didn't get any response, so I have to assume I was asking in the wrong place......I'm working with the EntityFramework.Core and EntityFramework.MicrosoftSqlServer ...
asked by Evan Verney-Fink
ASP.NET Core RC2 Seed Data using Services
I've been using ASP.NET 5 RC1 in which I've an application in which I seed administrative credentials into the data base using Services as follows:...public void ConfigureServices(IServiceCollection services) { services.AddEntityFramework() ...
asked by Janshair Khan
How to do Migrations and SQL Server connection on MacOS
I'm in OSX and I'm creating a new ASP.NET Core Web API. I've followed this tutorial: ...https://docs.efproject.net/en/latest/platforms/netcore/new-db-sqlite.html...That's cool and all but what about Sql Server? Now I know SQL Server won't yet run on OSX (...
asked by Prof
How to set another value on a boolean with defaut value with Entity Framework Core?
I got quite the same problem in this question : ...How to override SQL Server default value constraint on a boolean when inserting new entity? [closed]...Like him, I get the good value of my boolean from the client to the controller, false, but it's set t...
asked by Korgoth
How to generate an entity model from a query w/ EntityFrameworkCore
I'm trying to connect an ASP.NET Core web application to an existing, pretty complex database, in read-only mode....The database is much to complex to map its layout to EFC directly, I just access data from it via a set of queries. Those queries are well-...
asked by Johann Studanski
.net core and ef core sql server error provider: SQL Network Interfaces, error: 8 - Protocol not supported
I've been trying to develop a new application using .net core in MacOsX using a SQL Server database, but i'm having some problems with the connection because i'm getting the following error:...fail: Microsoft.AspNetCore.Server.Kestrel[13] Connecti...
asked by Leobardo Mora Castro
How do I visually design my database with Entity Framework Core?
I am wondering myself, how I should design my database scheme (in terms of efficiency and visuality)....I am developing a ASP.NET Core application with Angular 2 and I am using ...Entity Framework Core... (..."Microsoft.EntityFrameworkCore": "1.0.0"...), ...
asked by WoIIe
Page 1 of 9