Entity Framework 6 - Knowledge Base (KB)
20 results in tag: tsql
EntityFramework, C#, ExecuteStoreCommand returns -1?
I wanna get the next automatically incrementing primary key, ...Here... I understood to use T-SQL for doing that. So I wrote the following method :...public int GetLastNewsID() { const string command = @"SELECT IDENT_CURRENT ('{0}') AS Current_Identi...
asked by Mohammad Dayyan
Conditional WHERE in LINQ
Hi any suggestions on building a LINQ statement based on search criteria?...I'll be passing in an instance of a 'SearchCriteria' class with all parameters nullable....I then want to ...if (sc.a != null) // add to where if (sc.b != null) // add to...
asked by Jon H
How to perform delete rows on some condition with EF?
in ADO.NET I can use ...delete... statement...to delete some rows from an SQL table....what is the equivalent in Entity Framework?...How can I achieve that same result?...updateing with null objects isn't the same.
asked by Elad Benda
remote procedure call (RPC) protocol stream is incorrect
I use entityframework 5.0. I have so many test. If I run a test alone it passes, if I run this with the others eachother in the same time, it does not pass. There is no contact between the tests. Everytime one same query was sent. It would not be modified...
asked by Lajos
What is the equivalent of "CASE WHEN THEN" (T-SQL) with Entity Framework?
I have a Transact-SQl request that I use a lot and I want to get the equivalent with Entity Framework. But I don't know how to make a "CASE WHEN" statement with EF. Here is a simplified code of my request :...SELECT Code, SUM(CASE WHEN Month=1 THEN Days E...
asked by Alex
Database Issue - An error occurred while executing the command definition. See the inner exception for details
Trying to populate lists from my database as follows, here is the controller:...namespace TimetableSystem.Controllers { public class AvailabilityController : Controller { TimetableSystemEntities systemDB = new TimetableSystemEntities(); public Ac...
asked by bd99
How to RESEED LocalDB Table using Entity Framework?
Is There any way to ...RESEED... a ...LocalDB... Table using EF?...I'd prefer not to use this SQL Command :...DBCC CHECKIDENT('TableName', RESEED, 0) ...FYI : I'm using EF 6.1....Thanks alot.
asked by Mahdi Rashidi
Entity Framework 6 define a REALLY optional foreign key
Say I have two tables:...Products [ProductID] PK [Weight] [ProductCode] ...and...KnownProductCodes [ProductCode] PK [Description] ...Now I want my ...Product... entity to have a ...KnownProductCodeDetails... property. BUT the interesting thing here is tha...
asked by Maksym
How can I hydrate child objects using SQL from a single query?
I'm using Dapper, but I think this applies to general SQL: ...I have the following: ... var dapperQuery = "select * from ( select * from [User] where " + "AccountDisabled <> 1 and " + "Ra...
asked by SB2055
Does SQL Server automatically trim nvarchar fields upon query?
I have this query : ...select '[' + p.Firstname + ']' from Person p where p.Firstname = 'Johanne' ...In the table, I have multiple personne who have this firstname, and some have a trailing space on the value (bad insertion of the values, it will be corre...
asked by Shimrod
SQL Server and EF Migration from local to remote database
I'm working on an Entity Framework (EF) project that functions as a supplemental class library to another project within my Visual Studio 2013 solution. I initially had a mock local database on my client dev system and build out the schema and other util...
asked by Janus
create temp table and Store result of execute command at the same time
I have a stored procedure where I am running/executing a declared variable which is set to a select query for pivot table, important thing is that that pivot table is transforming column to n number of rows. Yes the rows are not fixed that is why I have p...
asked by Saleem
Stored Procedure returns no columns, only integer
I have a problem with the entitry framework 6.0.0.0 when I import the stored procedure no matter what I do it does not return the result set, instead it returns only integer or set to none. below is the sp. ...alter proc spGetProd @Prod nvarchar(500) as b...
asked by Saleem
Get an integer result from a stored procedure fails using Entity Framework when calling Context.Database.SqlQuery<int>
I am trying to call a stored procedure from Entity Framework in the following way:...Context.Database.SqlQuery<int>(sqlSP, params).FirstOrDefault(); ...but I get this error:...The data reader has more than one field. Multiple fields are not valid for EDM ...
asked by Heinrich
How can I remove a Column that has a Constraint with a migration from the DB (ASP.NET MVC5)
Each time I try dropping a column with the following migration:...public partial class RemoveProject_Id1InAspNetUsers2 : DbMigration { public override void Up() { DropColumn("dbo.AspNetUsers", "Project_Id1"); } ...
asked by Samseen
Get output 'inserted' on update with Entity Framework
SQL Server provides output for inserted and updated record with the 'inserted' keyword....I have a table representing a processing queue. I use the following query to lock a record and get the ID of the locked record:...UPDATE TOP (1) GlobalTrans SET Lock...
asked by Daniel
Entity Framework seed -> SqlException: Resetting the connection results in a different state than the initial login. The login fails.
I get the following exception when running the seed method for Entity Framework. I only get the exception once, if I run the seed method a second time when the database has already been altered the code works. What can I do so that I don't have to run the...
asked by Ogglas
Async/Await and Entity Framework SQL Procedure UI Thread Locking
I've been transitioning myself from BackGroundWorker to Async/Await programming. For the most part, it's been pretty simple. However, today I'm working with Entity Framework 6 and it's not playing nice. What I have here is a Procedure that I'm executing o...
asked by Kayot
No Complex Type created from new stored procedure, EF database first
I can not figure out why EF6 will not create a complex type for my stored procedure. I am using the database-first approach. ...I created a new stored procedure in SSMS 2017. Open my EDMX, right clicked "Update Model From Database," check my stored proced...
asked by Ben-Coden
How to use contains (T-SQL) in Entity Framework
I am looking for the equivalent of this feature of T-SQL:...SELECT * FROM dbo.users WHERE CONTAINS (name, 'Jack') ...in Entity Framework....Thanks....P.S. "contains" in linq is equivalent of LIKE in TSQL (eg., '%jack%'). I'm not looking for this because...
asked by Amir Parsi
