Book Image

ASP.NET Core MVC 2.0 Cookbook

By : Jason De Oliveira, Engin Polat, Stephane Belkheraz
Book Image

ASP.NET Core MVC 2.0 Cookbook

By: Jason De Oliveira, Engin Polat, Stephane Belkheraz

Overview of this book

The ASP.NET Core 2.0 Framework has been designed to meet all the needs of today’s web developers. It provides better control, support for test-driven development, and cleaner code. Moreover, it’s lightweight and allows you to run apps on Windows, OSX and Linux, making it the most popular web framework with modern day developers. This book takes a unique approach to web development, using real-world examples to guide you through problems with ASP.NET Core 2.0 web applications. It covers Visual Studio 2017- and ASP.NET Core 2.0-specifc changes and provides general MVC development recipes. It explores setting up .NET Core, Visual Studio 2017, Node.js modules, and NuGet. Next, it shows you how to work with Inversion of Control data pattern and caching. We explore everyday ASP.NET Core MVC 2.0 patterns and go beyond it into troubleshooting. Finally, we lead you through migrating, hosting, and deploying your code. By the end of the book, you’ll not only have explored every aspect of ASP.NET Core MVC 2.0, you’ll also have a reference you can keep coming back to whenever you need to get the job done.
Table of Contents (26 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Using a stored procedure with EF


In this recipe, we will learn how to use stored procedures in EF.

Getting ready

As in the previous recipes, we will continue to use the same CookBook database and to use xUnit to create unit test methods.

How to do it...

We will create a repository:

  1. First, we create two stored procedures in the CookBook database:
CREATE PROCEDURE [dbo].[GetBooks] 
AS
BEGIN
 SET NOCOUNT ON;
 SELECT [Id],[Name] FROM [dbo].[Book]
END
GO

CREATE PROCEDURE [dbo].[InsertBook]
 @name varchar(50)
AS
BEGIN
 SET NOCOUNT ON;
 INSERT INTO [dbo].[Book] ([Name]) VALUES (@name)
END
GO
  1. After that, we add two methods corresponding to the two stored procedures just created to DbContext:
    • First, we add GetBooks:
    • Then, we add InsertBook:
  1. Next, let's consume these methods: