Entity Framework Core - Knowledge Base (KB)
70 results for: in tag: sql
Entering keys manually with Entity Framework
I'm trying to use Entity Framework code first for a simple database project and I run into a problem I simply cannot figure out. ...I noticed EF was setting the ID for my tables automatically increasing by 1 each time, completely ignoring the value I ente...
asked by JCafe
Entity Framework 7 IDENTITY_INSERT
I need to store a large amount of user data in a database where every user already has an ID as a key. However, these users all out of a larger pool of users, therefore, the ID does not increment and cannot be automatically generated. I need to be able to...
asked by Jacob Linney
Entity Framework Core - .Contains() - Why escaping instead of parametrization?
In a web application, I get user input in the form of a ...List<string>... from the ViewModel and use this information to select the Ids of the users with the following code:...var selectedUsersIds = Context.Users .Where(user => SelectedUsers.Contains(us...
asked by GeorgDangl
Entity Framework Core - LINQ select over navigational properties creates invalid query
Currently, I'm working on an Asp.Net Core website and use Entity Framework Core (currently RC1) for database access with SQL Express LocalDB on the development machine, although MS SQL on the test server gives the same error....I've run into an issue that...
asked by GeorgDangl
How to turn off cascade delete in Entity Framework Core 1.0 RTM
Hi I have MVC 6 application with Entity Framework Core 1.0 RTM and SQL server, when I try to generate database tables, I got "Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths" error....My model classes are as below:...Category...
asked by bearview
How to force default values in an insert with EntityFramework core?
When adding a record with EntityFramework Core, if I want to force a column wich has a default value to annother value, the default value is taken....SQL...CREATE TABLE MyEntity( Id INT IDENTITY(1,1) NOT NULL, MyProperty1 VARCHAR(50), MyBool ...
asked by Korgoth
EF Core - dropping a column workaround (sqlite)
It ...is documented... and known that EF core migration scripts don't support dropping a column. So I'm trying to do it by hand....My model classes are:...class Master { public int Id { get; set; } public string ToBeDeleted { get; set; } } class ...
asked by johnildergleidisson
EF Core Check constraint
Is it possible to add a check constraint to a table via EF core....I have been looking around the only question I found is for Ef 7 with an anwesr over a year ago. So I am just wandering if anything has changed. Which gave the answer as below:...migration...
asked by Heinrich
How to Specify Entity Framework Core Table Mapping?
I've made a simple Entity Framework ASP Core Application which works but I do not know why:...I've made a context like this: ...public class AstootContext : DbContext { public AstootContext(DbContextOptions<AstootContext> options) : base(optio...
asked by johnny 5
StartsWith() doesn't translate to Like('abc%') in LINQ
I have the following asp.net core LINQ code:... List<UserSearchResult> results = await db.ApplicationUsers.Where(u => u.Name.StartsWith(name) && !u.Deleted && u.AppearInSearch) .OrderByDescending(u => u.Verified) ...
asked by Techy
UseInMemoryDatabase context isn't being shared across unit tests
I'm using Entity Framework Core ...2.0-preview1... with InMemory ...2.0-preview1.... Each unit test class inherits a disposable class that creates a new in memory database that its parents can use.... public Constructor() { var services = n...
asked by Kieran Devlin
Update-Database command is not working in ASP.Net Core / Entity Framework 6 because object in database already exists
I was updating my database by the command line, but then I manually updated one of my tables. ...This seems to have disrupted my ability to update-database. I receive the following error when I try to update: ... System.Data.SqlClient.SqlException: There ...
asked by Kelsey Steele
EF Core / Sqlite one-to-many relationship failing on Unique Index Constraint
The context is each ...Car... has a corresponding ...CarBrand.... Now my classes are as shown below:...public class Car { public int CarId { get; set; } public int CarBrandId { get; set; } public CarBrand CarBrand { get; set; } } public class...
asked by Jan Paolo Go
Single Address table used to store addresses for many entities (using double foreign key) with Entity Framework
I am attempting to use a single ...Address... table to store addresses for several entities in the system with a generic ...KeyId... field. A Customer can have multiple addresses and a Vendor can have multiple addresses....Address... class:...public int I...
asked by Blake Rivell
Raw sql with EF Core and in-memory db provider
One of my API routes uses a raw sql ...merge into... command in order to do an atomic upsert operation, and in my automated tests I've got a ...TestServer... instance that uses the in-memory db provider. It gives me an error, probably because the in-memor...
asked by gzak
InvalidOperationException due to circular dependency in Entity Framework Core
I am getting the following ...InvalidOperationException... when I try to save an entity with a one-to-one relationship:...System.InvalidOperationException: Unable to save changes because a circular dependency was detected in the data to be saved: 'Forei...
asked by Martin Brandl
Entity Framework .NET Core 2.0 Query hangs on execution when subquery is executed
With a regular version of EF 6.x I was able to do subqueries pretty easy with the following query:...var q = from u in db.User let actions = from ua in db.UserActions where ua.UserId == u.Id && ua.Approved ...
asked by Alexey Strakh
EntityFramework (.NET Core) left outer join by multiple conditions
I need to match ...User... and ...UserAction... by several criteria: ...UserId..., ...ActionType..., ...Approved..., and still want to keep the query as ...left outer join..., because the action could be missing. In regular .net entity framework I would d...
asked by Alexey Strakh
Entity Framework Core equivalent of SQL's "IN"
In EF Core 1.1, I can get all users which have a certain ClientId:...var users = _context.Users.Where(u => u.ClientId == 1) ...But is it possible to return all users that have a ClientId that fall in a set? Something like...var users = _context.Users.Wher...
asked by Fabricio Rodriguez
Entity framework core Output parameter not working in store procedure using FromSql method (Linq)
I am trying to get output value from the ...dbcontext... using the method ...FromSql(...).......If i execute it on SSMS, it works but not working in EF core....My SP param:... @totalItems VARCHAR(MAX) OUTPUT ...I've removed other params for readable and...
asked by Robin
Page 1 of 4