Using Typed Views

For Entity Framework v4, LLBLGen Pro supports Typed View definitions mapped onto a stored procedure resultset. You can map a Typed View on a single resultset, and the stored procedure returning the resultset can only return a single resultset as well, multiple resultset returning stored procedures aren't supported.

In the generated context class, a method is generated for every typed view definition mapped onto a stored procedure resultset, with the name GetTypedViewNameTypedView. The method has a parameter for every stored procedure parameter, equal to the call methods for normal stored procedure calls. The typed view fetch method returns an ObjectResult<TypedViewNameTypedViewRow> object.

In the example below a typed view, called CustomerOrderOrdersResult is mapped onto the resultset of the stored procedure CustOrderOrders of the Northwind database.

var ctxt = new NorthwindDataContext();
var typedViewRows = ctxt.GetCustomerOrderOrdersResultTypedView("ALFKI");