Visual C# 2005 Express: Database Project Question
-
Hi, I have been looking around and working with the Express editions of C# and SQl Server 2005 for a few days now. Currently I am unable to create a Procedure using the new CLR. From my understanding you must create a "special" stored procedure project that you later use in SQL Server 2005 by creating an assembly and linking to it... My problem is the Express version of C# does not include the template files for this. As a matter of fact there is no database project folder at all. I was wondering if there is somewhere I can download the needed templates or if I have to upgrade my version of C#. Thank you for your time, Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien -- modified at 14:02 Thursday 12th January, 2006 Cant spell...:D
-
Hi, I have been looking around and working with the Express editions of C# and SQl Server 2005 for a few days now. Currently I am unable to create a Procedure using the new CLR. From my understanding you must create a "special" stored procedure project that you later use in SQL Server 2005 by creating an assembly and linking to it... My problem is the Express version of C# does not include the template files for this. As a matter of fact there is no database project folder at all. I was wondering if there is somewhere I can download the needed templates or if I have to upgrade my version of C#. Thank you for your time, Will I hate users. Not all of them, just the ones who talk.CP member: Al Einstien -- modified at 14:02 Thursday 12th January, 2006 Cant spell...:D
Also, did you enable CLR Integration[^]? For security reasons it is turned off by default. You might also get some good information here: CLR Stored Procedures[^] ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
-
Also, did you enable CLR Integration[^]? For security reasons it is turned off by default. You might also get some good information here: CLR Stored Procedures[^] ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell