Using Entity Framework and Raw SQL for stored procedures and exception handling

Entity Framework code-first error when using stored procedure with fields that have default value

I need to use a stored method to insert an entity. There is a column in the database table called...CreateDateTime... whose default value is...GetDate()... . ...I refuse to permit the stored process to set or update...CreateDateTime... column. ...If I dial the...dbcontext.SaveChanges()... However, after inserting a record and calling my stored me...

Calling Oracle stored procedure using Entity Framework with output parameter?

I have a straightforward Oracle stored procedure with one output parameter and three input parameters:...CREATE OR REPLACE PROCEDURE RA.RA_REGISTERASSET ( INPROJECTNAME IN VARCHAR2 ,INCOUNTRYCODE IN VARCHAR2 ,INLOCATION IN VARCHAR2 ,OUTASSETREGISTERED OUT VARCHAR2 ) AS BEGIN SELECT INPROJECTNAME || ', ' || INLOCATION || ', ...

How to use SQL stored procedures with MVC Entity Framework

My coworker informs me that invoking SQL stored procedures is not supported by ASP.NET MVC with Entity Framework Core. Is this a fact? Where can I get instructions on how to accomplish this if not? Thanks!

Error trying to execute update stored procedure using entity framework core

ZZZ_tmp

Generating and accessing stored procedures using Entity framework core

Using Visual Studio 2017, I am developing the Asp.Net Core Web API, entity framework core, and database-first approach. I've been successful in creating the context and class files using an existing database. I must use my context to retrieve saved routines. In older versions of the entity framework, it was straightforward to create an edmx that in...

Entity framework core Output parameter not working in store procedure using FromSql method (Linq)

ZZZ_tmp

Entity Framework Core - Execute raw sql - Same code for SQL/SQLite

ZZZ_tmp

Entity Framework 6 vs Entity Framework Core Raw Sql

ZZZ_tmp

Secure way of accessing SQL Stored Procedures from Entity Framework Core

ZZZ_tmp

How to call stored procedure in Entity Framework Core with input and output parameters using mysql

ZZZ_tmp