CODEWITHSUNDEEP
c#.netpostgresqlfunctionnull
Thanh Nguyen
Thanh Nguyen

Reputation: 319

How to set null to Integer in function posgrest from C#

I am confused about the solution of passing the parameter null to integer type. Here is my code in my .Net project with angular. Thanks for your help.

if(data.searchRange != "") 
{
    m_npgDB.SetParams("p_searchRange", int.Parse(data.searchRange)); 
}
else
{
    m_npgDB.SetParams("p_searchRange", ""); 
}

Upvotes: 0

Views: 505

Answers (1)

Fabio
Fabio

Reputation: 32455

You just creating a parameter

if (int.TryParse(data.searchRange, out var range))
{
    m_npgDB.SetParams("p_searchRange", range); 
}
else
{
    m_npgDB.SetParams("p_searchRange", null); 
}

You should be able to use nullable integer

var value = int.TryParse(data.searchRange, out var range) ? range : default(int?);

m_npgDB.SetParams("p_searchRange", value);

Upvotes: 1

Related Questions