{"id":239,"date":"2014-08-27T06:41:41","date_gmt":"2014-08-27T06:41:41","guid":{"rendered":"http:\/\/mairwa.com\/wordpress\/?p=239"},"modified":"2014-08-27T06:41:41","modified_gmt":"2014-08-27T06:41:41","slug":"stored-proceduredbcontext-and-dbset-in-entity-framework","status":"publish","type":"post","link":"http:\/\/mairwa.com\/wordpress\/?p=239","title":{"rendered":"Stored procedure,Dbcontext and Dbset in Entity framework"},"content":{"rendered":"

Stored procedure use in EF<\/b><\/code><\/p>\n

Stored procedures and user-defined functions (UDFs) in the database are represented as functions in entity framework. So EDM won\u2019t have any entity or other stuff for stored procedures in the EDM designer.<\/p>\n

USE [MyDB]<\/p>\n

GO<\/p>\n

\/****** Object:\u00a0 StoredProcedure [dbo].[InsertRole]\u00a0\u00a0\u00a0 Script Date: 08\/27\/2014 11:10:29 ******\/<\/p>\n

SET ANSI_NULLS ON<\/p>\n

GO<\/p>\n

SET QUOTED_IDENTIFIER ON<\/p>\n

GO<\/p>\n

CREATE PROCEDURE [dbo].[InsertRole]<\/p>\n

(<\/p>\n

@roleName varchar(100)<\/p>\n

)<\/p>\n

AS<\/p>\n

BEGIN<\/p>\n

INSERT INTO [Role]<\/p>\n

([RoleName])<\/p>\n

VALUES<\/p>\n

(@roleName)<\/p>\n

END<\/p>\n

We \u00a0would see in InsertRole stored procedure added in Function Imports<\/b> with new complex type InsertRole_Result in Model Browser. Whenever we import stored procedure into model, it creates new complex type with the name {sp name}<\/i>_Result by default.<\/p>\n

Following example is that how to define insertrole sp in model namespace and entities class.<\/p>\n

Function imports are based on stored procedures. To map a function import to a complex type, the columns returned by the corresponding stored procedure must match the properties of the complex type in number and must have storage types that are compatible with the property types.<\/p>\n

DbContext —<\/b>A DbContext instance represents a combination of the Unit Of Work and Repository patterns such that it can be used to query from a database and group together changes that will then be written back to the store as a unit.\u00a0 DbContext is conceptually similar to ObjectContext.<\/p>\n

 <\/p>\n

When using the Code First approach, the System.Data.Entity.DbSet<TEntity>properties on the derived context are used to build a model by convention.<\/p>\n

 <\/p>\n

namespace TypeSettingWeb.Models<\/p>\n

{<\/p>\n

using System;<\/p>\n

using System.Data.Entity;<\/p>\n

using System.Data.Entity.Infrastructure;<\/p>\n

using System.Data.Entity.Core.Objects;<\/p>\n

using System.Linq;<\/p>\n

public partial class MyEntities : DbContext<\/p>\n

{<\/p>\n

public MyEntities()<\/p>\n

: base(“name=MyEntities”)<\/p>\n

{<\/p>\n

}<\/p>\n

public virtual int InsertRole(string roleName)<\/p>\n

{<\/p>\n

var roleNameParameter = roleName != null ?<\/p>\n

new ObjectParameter(“roleName”, roleName) :<\/p>\n

new ObjectParameter(“roleName”, typeof(string));<\/p>\n

return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction(“InsertRole”, roleNameParameter);<\/p>\n

}<\/p>\n

}}<\/p>\n

 <\/p>\n

DbSet —<\/b>A DbSet represents the collection of all entities in the context, or that can be queried from the database, of a given type. DbSet objects are created from a DbContext using the DbContext.Set method.<\/p>\n

Following is use for Datatable mapping to EF.it is using of Dbset properties.<\/p>\n

public virtual DbSet<ActionPermission> ActionPermissions { get; set; }<\/p>\n

\u00a0<\/i><\/b><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Stored procedure use in EF Stored procedures and user-defined functions (UDFs) in the database are represented as functions in entity framework. So EDM won\u2019t have any entity or other stuff for stored procedures in the EDM designer. USE [MyDB] GO \/****** Object:\u00a0 StoredProcedure [dbo].[InsertRole]\u00a0\u00a0\u00a0 Script Date: 08\/27\/2014 11:10:29 ******\/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[InsertRole]… Read more →<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-239","post","type-post","status-publish","format-standard","hentry","category-c-vb","xfolkentry"],"_links":{"self":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/239","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=239"}],"version-history":[{"count":0,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/239\/revisions"}],"wp:attachment":[{"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=239"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/mairwa.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}