Use this function to convert before sending it to stored procedure
public static string FirstCharToUpper(string input)
{
if (String.IsNullOrEmpty(input))
throw new ArgumentException("Error");
return input.First().ToString().ToUpper() + String.Join("", input.Skip(1));
}
this will convert every first letter of string to Upper
public static string FirstCharToUpper(string str)
{
return CultureInfo.CurrentCulture.TextInfo.ToTitleCase(str.ToLower());
}