CODEWITHSUNDEEP
sql-server
John S
John S

Reputation: 8349

Storing Long/Lat in Sql Geography column or simpler column?

This is the first time I have tried using the DbGeography type in my EF Code First design. My question is Should I be using simple float fields to hold the longitude and latitude of a location or should I be using the SQL type geography?

I'm beginning to think that geography is making things way more complex then they need to be. I will be doing some area calculations based on the long/lat.

Upvotes: 4

Views: 286

Answers (1)

Jeffrey Van Laethem
Jeffrey Van Laethem

Reputation: 2651

If you think you're going to make use of the functions and other conveniences the Geography type provides I'd use the data type. Otherwise, float would be fine.

Upvotes: 1

Related Questions