Why CLR stored proceduer ?

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 ??? 

Answer 1

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.

Answer 2

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.