I think what I want to do can only be accomplished manually, but thought I would ask anyway as it feels like this should be possible using the designer.
When reverse engineering a database model, I had a number of stored procedures that return defined entities. The Open Access Domain Model reverse mapped this fine but it created very generic function imports. For example
spProductsGet(@CategioryId INT) -- turns into -> object spProductsGet(int CategoryId)
What would be helpful is the ability to map the rerun type, and be able to define the method name using the designer. This way I could have it do something like:
spProductsGet(@CategioryId INT) -- be mapped to -> IList<Products> GetProducts(int CategoryId)
And still preserve the ability to make changes and update the model from the db.
An workaround alternative might be to change the code generator to use generics for the stored procedures.Ex:
? categoryId) where T :
SqlParameter parameterCategoryId =
List<SqlParameter> sqlParameters =
IList<T> queryResult =
, sqlParameters, categoryId);