Store Procedure

Question

Dear experts I'd like to know if we still have to create our Value Objects if we were to use Stored Procedure? And since we have all the result we want which we stored in the store procedure then how should we go about doing it in the Model class ? Last but not least any useful step by step procedure would be most appreciated. Tks again.

Tangara G · Answer

Er...I forgot to add that entity framework is not allowed in this company.....so how?

Bikesh Srivastava · Answer

In simple word strored procedure is a collection which can contains multiple query and give set of result in table form.

Pradeep Sahoo · Answer

Stored procedure returns us the result in terms of different fields . For mapping to model class we need to assign the model class to the different properties of stored procedure . To achieve this easily we have entity framework which does the mapping between model class and stored procedure. Please read : http://www.entityframeworktutorial.net/EntityFramework5/CRUD-using-stored-procedures.aspx