Peter S

My feedback

  1. 207 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Peter S commented  · 

    I like all Entity Framework data access to automatically create and map to store procedure instead of calling sp_executesql with parameterized query.
    Advantages are:
    • All database code in one place!!!!!
    • Enables check by ”SQL Upgrade advisor”
    • System view for dependency checks
    • Using visual studio for static code analysis
    • Enables DBAs to see which questions are run
    • Enables DBAs to customize T-SQL, inde
    • Only need to grant excite stored procedure rights indeed of base table access
    • The use of stored procedure cache
    • May be even version control of the sps with database projects and TFS

    Peter S supported this idea  · 

Feedback and Knowledge Base