none
Why CLR stored proceduer ? RRS feed

  • Question

  • Hi, i'm working on a client/server dental managment application and i'm confusing about whether using stored procedure located in sql server or using CLR stored procedure created in C# , which is the best for my application ? and i'm fread of some one doing a deassembling for my application and see my CLR stored procedure ??? 
    Tuesday, April 2, 2013 8:22 PM

Answers

  • Hi lola24,

    To choose between CLR and T-SQL stored procedures, I suggest you to read the following link.

    https://www.simple-talk.com/sql/learn-sql-server/choosing-between-clr-and-t-sql-stored-procedures-a-simple-benchmark/

    Best Regards,

    This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    Bob Wu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, April 8, 2013 8:48 AM
    Moderator

All replies

  • Yes, you can use the SQL procedure, and I suggest you try this one, specially as security reason.

    Have a nice day.


    Ghost,
    Call me ghost for short, Thanks
    To get the better answer, it should be a better question.

    Sunday, April 7, 2013 2:10 PM
  • Hi lola24,

    To choose between CLR and T-SQL stored procedures, I suggest you to read the following link.

    https://www.simple-talk.com/sql/learn-sql-server/choosing-between-clr-and-t-sql-stored-procedures-a-simple-benchmark/

    Best Regards,

    This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.


    Bob Wu
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Monday, April 8, 2013 8:48 AM
    Moderator