C# SQL CLR - convert SqlString to String

Question

This works but I want to convert SqlString to String and do String.Length. If String.Length is e.g. 5, I want to display in cell (in table in SQL Server) e.g. Active, but if not, I want to display the current field value.

public class proveraMb
{
    [Microsoft.SqlServer.Server.SqlFunction]
    public static SqlString matbr (SqlString ispravan)
    {
        SqlString i = ispravan;

        if (i == "ss")
            return i;
        else
            return "nije dobar";
    }
}

Solomon Rutzky · Accepted Answer · 2019-01-20 21:46:32Z

3

While the ToString() method does work, it is better to use (and get used to using) the Value property. The reason that this is better is that all Sql* types have a Value property that returns the expected native .NET type. So SqlInt64.Value returns a long, SqlDateTime.Value returns a DateTime, etc.

answered Jan 20, 2019 at 21:46

Solomon Rutzky

49.3k11 gold badges141 silver badges185 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruno Caceiro · Accepted Answer · 2019-01-20 19:21:22Z

1

You just need to call the ToString() method

Sample

SqlString i = ispravan;
string test = i.ToString();

answered Jan 20, 2019 at 19:21

Bruno Caceiro

7,2091 gold badge29 silver badges46 bronze badges

Comments

Niels Berglund · Accepted Answer · 2019-01-21 02:43:34Z

1

Each SqlType has a Value property. This property gives you back the value of the SqlType cast to the native type.

answered Jan 21, 2019 at 2:43

Niels Berglund

1,70810 silver badges6 bronze badges

Collectives™ on Stack Overflow

C# SQL CLR - convert SqlString to String

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related