Entity Framework 4.1: Expert's Cookbook by unknow

Author:unknow
Language: eng
Format: epub
Publisher: Packt Publishing

In the DataAccess project, we add a new folder named Queries with a new C# class named StoredProcedures, with the following code:using System.Linq; namespace DataAccess.Queries { public static class StoredProcedures { public static int GetBlogCount(this IBlogRepository repository) { var items = repository.UnitOfWork.Context.Database .SqlQuery<int>(@"GetBlogCount"); var count = items.FirstOrDefault(); return count; } } }

Run our test, and see how it works.

How it works...

We start-off our solution, as always, with a test that ensures that our features are properly implemented, and that we have demonstrated the functionality required.

In this example, for clarity alone, we have put the definition of the stored procedure into our code. This is not a requirement, and we could have easily let the stored procedure be defined in an embedded SQL file, or have it already exist in the database.

Once the stored procedure is created, we put an extension method on the repository that allows us to invoke the SQL statement from the Database object on the DbContext. We have to drill through a couple of layers, but this is preferable to surfacing a raw DbContext. We want that layered abstraction in this case.

Entity Framework takes the SQL query, executes it, and then tries to map the return operation into the type that we have given it. In this case, we told it that the return parameter is of the integer type.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.