CODEWITHSUNDEEP
c#sql-serverentity-frameworkentity-framework-coreef-core-3.0
Ashkan Mobayen Khiabani
Ashkan Mobayen Khiabani

Reputation: 34152

Scaffold-DbContext Stored Procedures only in EF Core

I have always used code-first with EF Core, Now I need to use Database-First. There are lots of questions, documents, and tutorials about this, teaching how to scaffold a database, 

Scaffold-DbContext "Server=(localdb)\mssqllocaldb;Database=Blogging;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models

However, my only requirement here is missing in all of them. I need to scaffold only a few stored procedures and views, but all these documents and question say is about how to include tables.

I was going to scaffold including everything and then delete unwanted ones manually, but it doesn't seem to be the right choice.

Upvotes: 7

Views: 13163

Answers (3)

Dash
Dash

Reputation: 834

Just in case someone landed here looking to execute stored procedure in MySQL database from EntityFramework Core, the following code should work.

var blogTagId = 1;
var tags = await _dbContext.BlogTags.FromSqlRaw("CALL SP_GetBlogTags({0})", blogTagId).ToListAsync();

Upvotes: 1

StepUp
StepUp

Reputation: 38094

It is possible to call a raw SQL using ExecuteSqlCommand. So code to call stored procedure would be look like that:

context.Database.ExecuteSqlCommand("YourStoredProcedure @p0, @p1", 
    parameters: new[] { "Joseph", "Gates" });

UPDATE:

As msdn says about how to get rows from stored procedures:

Raw SQL queries can be used to execute a stored procedure.

var user = "johndoe";

var blogs = context.Blogs
    .FromSqlRaw("EXECUTE dbo.GetMostPopularBlogsForUser {0}", user)
    .ToList();

The following example uses a raw SQL query that selects from a Table-Valued Function (TVF), then disables change tracking with the call to AsNoTracking:

var searchTerm = ".NET";

var blogs = context.Blogs
    .FromSqlInterpolated($"SELECT * FROM dbo.SearchBlogs({searchTerm})")
    .AsNoTracking()
    .ToList();

Upvotes: 6

ErikEJ
ErikEJ

Reputation: 41759

Use EF Core Power Tools, it allows you to select what to scaffold, and saves your selection.

Upvotes: 6

Related Questions