SqlCommand.CommandTimeout Not Support.

 
Hi Dear Sir,

I have some problem:

SqlCommand.CommandTimeout not support.

My SQL Query:


 public static List<Subject> GetAllSpecificUrlSubject(int memberId)
    {
       
string sql = string.Concat("SELECT distinct S.subject_id as 'id',
cast(S.subject_raw as varchar(8000)) as 'subject' FROM STATEMENT
S,Custom_Blogs B INNER JOIN onsurvey.member_custom_blogs M ON
B.Blogs_ID=M.Blogs_Id where M.MemberId="+ memberId +" and
cast(S.blog_url as varchar(8000)) like '%'+ cast(B.Url as
varchar(8000)) COLLATE SQL_Latin1_General_CP1_CI_AS +'%' group by
S.Subject_Id,cast(S.Subject_Raw as varchar(8000))");

        List<Subject> list;

        using (SqlConnection conn = OLSUtils.DBUtils.SqlConnectionUtils.GetNewConnection())
        {
            using (SqlCommand cmd = conn.CreateCommand())
            {
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
               //cmd.CommandTimeout = 300;
                conn.Open();

cmd.CommandTimeout = 300;