Q: Save geography type to SQL Server My table has column with 'geography' type. How I can save data to this table with C# SqlGeography.Point() and ado.net? I have following code
var stringPos = item.Position.Split(',');
var latPos = double.Parse(stringPos[0], CultureInfo.InvariantCulture);
var longPos = double.Parse(stringPos[1], CultureInfo.InvariantCulture);

var position = SqlGeography.Point(latPos, longPos, 4326);

string query = @"INSERT INTO myTable VALUES (@position, @postCode)";

SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@position", position);
cmd.Parameters.AddWithValue("@postCode", item.ZipCode);

cmd.ExecuteNonQuery();

I have following code but it throws exception: 

UdtTypeName property must be set for UDT parameters.


A: Solution:
Change 
cmd.Parameters.AddWithValue("@position", position);

To
cmd.Parameters.Add(new SqlParameter("@position", position) { UdtTypeName = "Geography" });

