You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You need to use a spatial value type…

The correct answer is C. Set the parameter's SqlDbType to Udt. There are two types of spatial data. The geometry data type supports planar, or Euclidean (flat-earth), data. The geometry data type conforms to the Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0. In addition, SQL Server supports the…

advanced WCF features

Question

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. You need to use a spatial value type as a parameter for your database query. What should you do?

Options

ASet the parameter's SqlDbType to Binary.
BSet the parameter's SqlDbType to Variant.
CSet the parameter's SqlDbType to Udt.
DSet the parameter's SqlDbType to Structured.

How the community answered

(38 responses)

A
5% (2)
B
8% (3)
C
74% (28)
D
13% (5)

Explanation

There are two types of spatial data. The geometry data type supports planar, or Euclidean (flat-earth), data. The geometry data type conforms to the Open Geospatial Consortium (OGC) Simple Features for SQL Specification version 1.1.0. In addition, SQL Server supports the geography data type, which stores ellipsoidal (round-earth) data, such as GPS latitude and longitude coordinates. SqlParameter.UdtTypeName Gets or sets a string that represents a user-defined type as a CHAPTER 2 ADO.NET Connected Classes Lesson 2: Reading and Writing Data Working with SQL Server User-Defined Types (UDTs) (page 105) Types of Spatial Data

Topics

#spatial data types#SqlDbType.Udt#SQL Server 2008#SqlParameter

Community Discussion

No community discussion yet for this question.

Full 70-516 Practice