Peter S

My feedback

  1. 207 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      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