Change from a Table to a Stored Procedure in an existing model RRS feed

  • Question

  • Is there an easy way to change a model so that the data for a particular table comes from a Stored Procedure instead.

    I need to change the access for some data that needs to have one of the columns encrypted. So do be able to decrypt the data upon retrieval I need to access the data through a stored procedure rather than through a simple table mapping.

    I dont use EF much so reaching to see if there is an easy way to change this.


    Monday, December 17, 2012 6:06 PM


  • Hi KeithFranklin;

    If you already have the Stored Procedures in the database then please read this article by Julie Lerman which shows you how to use Entity Framework with stored procedures.

    Stored Procedures in the Entity Framework


    Fernando (MCSD)

    If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

    • Marked as answer by Alexander Sun Wednesday, December 26, 2012 2:47 AM
    Tuesday, December 18, 2012 1:01 AM