porting a c# dll from sql 05 to sql 2000

• Reza Mohamed

  SSC Rookie

  Points: 29

  More actions

  September 26, 2006 at 11:33 pm

  #92509

  I wrote a class in C# with one method that returns a string. I built the dll and deployed the clr into sql 2005 and everything works just fine.

  I am now in a situation where I need to use this function in SQL 2000. Is there any way that I can use the existing dll and create a sql 2000 function, and if so how do I go about doing this? If not using the existing dll, how would i go about doing this?

  Here is the c# code from the deployed dll.

  using System;

  using System.Data;

  using System.Data.SqlClient;

  using System.Data.SqlTypes;

  using Microsoft.SqlServer.Server;

  using System.Text.RegularExpressions;

   

   

  public partial class GECBI

  {

      [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic = true, IsPrecise = true)]

      public static string RegExMatch(string pattern, string matchString)

      {

          Regex r1 = new Regex(pattern);

          if (r1.Match(matchString.TrimEnd(null)).Success)

          {

              Regex testReg = new Regex(pattern);

              Match regMatch = testReg.Match(matchString);

              string runnumber = regMatch.ToString();

              return runnumber;

          }

          else

          {

              return null;

          }

       

      }

  };

• DanKennedy

  Hall of Fame

  Points: 3736

  More actions

  September 28, 2006 at 1:12 am

  #662918

  This might help

  http://www32.brinkster.com/srisamp/sqlArticles/article_33.htm

  ---

  Dan
  www.firstcs.co.uk