Database

1. create object "SqlConnection" and let connection opened during service (webservice) works
2. using the instruction below every time I want to do a modification in dtatabase

 using (SqlConnection sqlconnection = GetSqlConnection(connectionString, false))
                {
                    sqlconnection.Open();
.....

}

public static SqlConnection GetSqlConnection(string connectionString, bool disablePooling = true, bool forceMasterDB = false)
       {
           if (disablePooling || forceMasterDB)
           {
               SqlConnectionStringBuilder sqlConnBuilder = new SqlConnectionStringBuilder(connectionString);

               if (disablePooling)
                   sqlConnBuilder.Pooling = false;

               if (forceMasterDB)
                   sqlConnBuilder.InitialCatalog = "master";

               connectionString = sqlConnBuilder.ConnectionString;
           }
           return new SqlConnection(connectionString);
       }

1. Get the first 3 characters from a string, no matter alphabets or numerical values but not special characters, like for example if I have file name A00Temp then it should give me A00 and if the string is _A00Temp then still it should give me the A00 only but not _A0, if it has ABCTemp then it should give me ABC
2. the 2nd need is if I have a string with alphabets, numerical and special characters then it should give me only alphabets from that string
   for exmple if I have: Abc def 230 then I should get abcdef, if I the string is _abc$#def then I should get only abcdef.

SELECT * 
    FROM NexGen.dbo.AttemptedRuns
    WHERE BaySerialNumber = '1545300531'

SELECT  ar.Id as AttemptedRunId,
        ar.AccessionId,
        ar.StartTime,
        ar.BaySerialNumber,
        ar.CartridgeId,
        ar.Result as AttemptedRunResult,
        b.Location as BayLocation
    FROM NexGen.dbo.AttemptedRuns ar
    LEFT JOIN NexGen.dbo.Bays b on b.SerialNumber = ar.BaySerialNumber
    WHERE ar.BaySerialNumber = '1545300531'