Creating DbGeography from Lat Lon

14. June 2013 12:17 by martijn in dbgeography, entity framework

One of the trivial things I missed in EF5 DbGeography is a way to create a DbGeography from lat lon. I created a helper for just that:


public static class DbGeographyHelper


    public static  DbGeography FromLatLon(double lat,double lon)


        var p1 = string.Format("POINT({0} {1})", lon, lat);

        return DbGeography.FromText(p1);






good 9/7/2013 7:35:13 PM United States #

I really appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You have made my day! Thx again!

try 9/7/2013 8:39:44 PM United States #

I do agree with all of the ideas you have presented on your post. They're very convincing and will certainly work. Nonetheless, the posts are too quick for newbies. Could you please extend them a little from subsequent time? Thanks for the post.

phone sex 9/7/2013 10:43:08 PM United States #
phone sex

But wanna comment on few general things, The website style and design is perfect, the written content is really excellent. "I delight in men over seventy. They always offer one the devotion of a lifetime." by Oscar Fingall O'Flahertie Wills Wilde.

Dexter Esquer 9/10/2013 7:38:14 AM United States #
Dexter Esquer

I have been blogging since last month, my blog was indexed previously in google but in the course of the test i conducted, i explore on behalf of a confident keyword related taking place my blog but it only shows the blog title and it directs me to the homepage not resting on the real placement. Ought help!!!.

Handmade Jewelry 10/8/2013 9:38:38 PM United States #
Handmade Jewelry

Exceptional post nonetheless , I was wanting to know should you could write a litte much more on this subject? I’d be extremely thankful if you could elaborate a bit bit more. Thanks!

Hammered Copper Earrings 10/29/2013 1:00:49 AM United States #
Hammered Copper Earrings

It is almost impossible to discover knowledgeable males and ladies with this topic, and you sound like there’s a lot more you might be referring to! Thanks

Distinctive Copper Earrings 10/29/2013 9:21:44 PM United States #
Distinctive Copper Earrings

you’ve got an important weblog proper here! would you wish to make some invite posts on my blog?

Chic Copper Earrings 10/30/2013 7:54:28 AM United States #
Chic Copper Earrings

Thanks  for this post, I'm a big fan  of this  web internet site  would like to  proceed  updated.

Handmade Jewelry 11/2/2013 4:58:18 AM United States #
Handmade Jewelry

Some  genuinely  prime  posts  on this internet site  , bookmarked .

Handmade Jewelry 11/3/2013 6:09:43 AM United States #
Handmade Jewelry

Thank you for your extremely excellent information and feedback from you. san jose used car

Handmade Jewelry 11/7/2013 4:35:46 AM United States #
Handmade Jewelry

Currently genuinely do not stop eating because there is however the decision which you will transform into. Function from your home us rrs often a fad for that who wants to earn dollars yet nonetheless enough time requires most substantial occasions utilizing children and kids goes for as the modern habit. attract abundance

Shera Selvaggi 11/7/2013 3:47:37 PM United States #
Shera Selvaggi

I love the blog.

Visit Website 11/12/2013 8:20:16 AM United States #
Visit Website

I want to to write to you you've really assisted me simply by publishing this unique content. I had been able to take your own extremely useful tips and put it to quite great usage. I'd like to express our appreciation and would like to inform your readers that they're so blessed to have someone like you creating amazing material. I anticipate studying more valuable content similar to this from you later on. Once more, thanks so much for the extremely helpful article. We have included your rss as well as book-marked you web site within my social bookmarking internet site. Cheers!

Veola Camarata 11/12/2013 8:14:07 PM United States #
Veola Camarata

Same here, i tried everything but still getting ,,the sim card inserted in this iphone does not appear to be supported,, error.<br />HELP!

call from Santa 12/6/2013 4:06:36 AM United States #
call from Santa

Hmm is anyone else experiencing problems with the pictures on this blog loading? I'm trying to find out if its a problem on my end or if it's the blog. Any feedback would be greatly appreciated.

Santa letters 12/7/2013 1:44:50 PM United States #
Santa letters

I'm not sure exactly why but this website is loading very slow for me. Is anyone else having this problem or is it a issue on my end? I'll check back later on and see if the problem still exists.

Claude 12/20/2013 2:05:29 AM United States #

Another thing I've really noticed is the fact that for many people, bad credit is the result of circumstances over and above their control. One example is they may are already saddled through an illness so that they have more bills going to collections. It might be due to a work loss or even the inability to go to work. Sometimes divorce or separation can send the finances in the wrong direction. Thank you for sharing your opinions on this blog site.

find out here 1/27/2014 3:26:00 PM United States #
find out here

I think other web-site proprietors should take this site as an model, very clean and wonderful user friendly style and design, let alone the content. You are an expert in this topic!

us soccer schedule world cup 2/6/2014 5:34:11 AM United States #
us soccer schedule world cup

Hi there; I think this is maybe as good a place as any to get in touch & let you know that, when I attempt to look at your RSS I get an error: "Internet Explorer cannot display this feed. This feed contains code errors. Go back to the previous page."? If its not something on my end then I hope that you can repair it - I would like to add your rss feed to Google Reader. Looking forward to hopefully doing so soon. All the best, Christel Heroman from Leiyang

Pamala 2/6/2014 4:35:47 PM United States #

You information has been of great help, nice work

AVON Clearskin blemish clearing 2/7/2014 4:49:57 PM United States #
AVON Clearskin blemish clearing

I tried to post a comment earlier, although it has not shown up. I believe your spam filter may well be broken? 2/17/2014 4:40:11 PM United States #

Valuable information. Lucky me I found your website by chance, and I'm shocked why this coincidence did not took place in advance! I bookmarked it.

free iphone emulator 2/22/2014 1:13:11 AM United States #
free iphone emulator

nice share,Thanks for the informations dont forget to drop by my link and apply to be able to win a free iphone 5c

crystal 2/23/2014 1:06:12 PM United States #

Always excellent to discover information that can assist, cheers

crystal 2/23/2014 8:13:55 PM United States #

More details like this will be fantastic, hope I can visit once more and use it.

Kit 3/1/2014 4:49:09 PM United States #

I like what you have done here, please keep providing stella information.

Twyla 3/1/2014 6:27:15 PM United States #

There are so many blogs online, I'm glad I found yours today, keep it up.

Deena 3/4/2014 9:03:41 AM United States #

The post was real good for my research, hopefully I can find more comparable information

CHAT 3/12/2014 2:43:32 AM United States #

Very interesting info!Perfect just what I was looking for!

teeth whitening 3/22/2014 6:19:15 AM United States #
teeth whitening

Nice job on providing the details, this was really handy.

look at more info 5/2/2014 6:41:06 PM United States #
look at more info

I really like your writing style, superb information, regards for putting up Laughing. "If a cluttered desk is the sign of a cluttered mind, what is the significance of a clean desk" by Laurence J. Peter.

Myrta 5/5/2014 9:06:47 AM United States #

When some one searches for his required thing, thus he/she needs to be available that in detail, thus that thing is maintained over here.|

visit 5/16/2014 3:52:33 AM United States #

Just  wanna  input on few general things, The website  design and style  is perfect, the  written content  is very   fantastic  : D.

Rupert 5/25/2014 8:45:55 AM United States #

Its like you read my mind! You seem to grasp so much approximately this, like you wrote the book in it or something. I believe that you simply could do with some p.c. to drive the message home a bit, but instead of that, that is magnificent blog. A great read. I'll certainly be back.|

Stanford 5/25/2014 10:12:04 PM United States #

Hello there, simply was aware of your weblog via Google, and found that it's really informative. I'm going to watch out for brussels. I will appreciate when you proceed this in future. A lot of other folks will be benefited from your writing. Cheers!|

snipping tool 6/16/2014 10:00:41 PM United States #
snipping tool

This was a fantastic read. Thank you for sharing it around! Nowadays the net is full of poor content there is however no doubt which you spent much time by editing this article. Again, we appreciate you your time as well as for your efforts!

Pantofi Barbatesti 6/18/2014 12:43:44 PM United States #
Pantofi Barbatesti

Simply because I at first wrote regarding MBT sneakers at <strong><a href=""; title="Pantofi Barbatesti">Pantofi Barbatesti</a></strong>, a great deal consists of modified above the model, and the inventor and founder contains still left the small business. Concerning accurate buyers, critiques of MBT footwear are fairly merged. If yourself're looking at a few of MBT sneakers, I strongly persuade on your own towards additionally read through the feedback remaining in just solution in the direction of the after content articles, and communicate in direction of your physician in advance of carrying any style of shoe that is consequently significantly alternative versus what yourself're applied in direction of, or toward take care of any design and style of discomfort or trouble.

peeter 4/7/2015 8:49:55 AM #

Deccan Chronicle is the most unmistakable English tongue step by step day by day paper in India telling the greatest readership in India. Your Classified Ad Bookings in Deccan Chronicle would without a doubt attain to your proposed target swarms

Zachery Gilio 4/12/2015 11:25:02 AM United States #
Zachery Gilio

Your style is really unique compared to other people I've read stuff from. I appreciate you for posting when you have the opportunity, Guess I will just book mark this page.

Reuben Pliml 4/19/2015 3:33:57 PM United States #
Reuben Pliml

It’s hard to come by knowledgeable people for this topic, however, you seem like you know what you’re talking about! Thanks

Dropbox Tips Tricks 4/29/2015 4:29:14 AM United States #
Dropbox Tips Tricks

I truly love your blog.. Great colors & theme. Did you create this web site yourself? Please reply back as I�m attempting to create my very own website and would like to know where you got this from or just what the theme is named. Thank you!

Nelly Murff 5/11/2015 7:32:56 AM United States #
Nelly Murff

H Sign workWordPress Article R <a href=">"></a>

Book of Ra 5/26/2015 7:47:29 PM United States #
Book of Ra

Einfach unschlagbar – bislang kosteten selbst EINZELNE Anleitungen mit Tricks für den beliebten Slot im Casino oftmals über 500 Euro aufwärts. Dank eines revolutionären Programmiertricks ist es nun erstmals einer Gruppe von Profispielern gelungen, den Book of Ra Algorithmus zu 557545294_icon60entschlüsseln!!!

Reva Nate - HR Software 5/27/2015 4:27:58 PM United States #
Reva Nate - HR Software

Hi there! Your post rocks too as getting a reputable great recognize!??

Belle Ceo 6/5/2015 4:02:55 AM United States #
Belle Ceo

I can't figure out how do I subscribe to your blog

Nanci Pithan 6/10/2015 4:00:10 AM United States #
Nanci Pithan

Howdy! This post couldn't be written any better! Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this write-up to him. Fairly certain he will have a good read. Many thanks for sharing!

Claretha Matier 6/10/2015 8:09:59 PM United States #
Claretha Matier

Hi would you mind letting me know which webhost you're using? I've loaded your blog in 3 completely different web browsers and I must say this blog loads a lot quicker then most. Can you suggest a good web hosting provider at a reasonable price? Cheers, I appreciate it!

Ronni Redel 6/29/2015 5:35:50 AM United States #
Ronni Redel

When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added I get four emails with the same comment. Is there any way you can remove me from that service? Thanks a lot!

Marcelle Nivison 7/7/2015 6:00:16 AM United States #
Marcelle Nivison

Hii are you interested in some cheap items to xbox and playstation 4, code emailed? Have a nice evening Smile

Britt Stobbe 7/18/2015 4:03:12 PM United States #
Britt Stobbe

Read - Tom Watson emotional farewell walk.

free music downloads 7/22/2015 4:23:43 AM United States #
free music downloads

free mp3 download site

simply click the up coming internet page 7/26/2015 10:34:32 AM United States #
simply click the up coming internet page

Thanks for the function. Post helped me quite a bit

unique bikinis 7/28/2015 12:33:39 PM United States #
unique bikinis

I've been browsing on-line greater than 3 hours nowadays, yet I never discovered any fascinating article like yours. It is lovely price enough for me. In my view, if all site owners and bloggers made just right content as you did, the net will likely be much more helpful than ever before. "Wherever they burn books, they will also, in the end, burn people." by Heinrich Heine.

Agua Bendita Quetzal 7/28/2015 6:39:30 PM United States #
Agua Bendita Quetzal

agua bendita peru 7/28/2015 7:28:47 PM United States #
agua bendita peru

swimsuit agua bendita 7/29/2015 12:37:39 PM United States #
swimsuit agua bendita

F*ckin' remarkable issues here. I am very glad to see your article. Thanks a lot and i am having a look forward to touch you. Will you kindly drop me a mail?

Marco 8/5/2015 6:17:29 PM United States #

Hi everybody, I'm an Italian man decided to send a message which will describe my personality. Long ago there were transmitted values by GOD and JESUS, and at that time people felt it more consideration. Nowadays, the observance of these principles has started a process of decay. This consideration of the values is not only vital in personal relationships between men and women, but also towards present and future society, which learns and will learns our behaviour patterns. All this means that the more time passes, the less importance has the lives of others. A couple must have a very strong faith in order to address all the problems that life delivers, so it is necessary that each other are offset by a fidelity that is based precisely on the concepts above. IT'S ESSENTIALS THAT AS MANY PEOPLE AS POSSIBLE DIFFUSE THE GOSPEL ALL OVER THE WORLD. My main characteristic is focused on being God-loving, for this reason i'm very reliable in relationships. Nobody is perfect, but this particular side makes safer a person who is interested to become a part of my life. I am willing to start something special that will lead to the development of a more solid bond. I'm available to relocate everywhere because for me geographical distance is purely a matter of jumping on a plane and next second virtual world became reality. John 6:35 Jesus said to them, "I am the bread of life. The one who comes to me will never go hungry, and the one who believes in me will never be thirsty. John 6:36 But I told you that you have seen me and still do not believe. John 6:37 Everyone whom the Father gives me will come to me, and the one who comes to me I will never send away. John 6:38 For I have come down from heaven not to do my own will but the will of the one who sent me. John 6:39 Now this is the will of the one who sent me – that I should not lose one person of every one he has given me, but raise them all up at the last day. John 6:40 For this is the will of my Father – for everyone who looks on the Son and believes in him to have eternal life, and I will raise him up at the last day.""

agua bendita swimsuit 8/6/2015 10:22:23 PM United States #
agua bendita swimsuit