Creating DbGeography from Lat Lon

14. juni 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);

    }

}

 

 

Enjoy!

good 7-9-2013 19:35:13 United States #
good

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 7-9-2013 20:39:44 United States #
try

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 7-9-2013 22:43:08 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 10-9-2013 07:38:14 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 8-10-2013 21:38:38 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 29-10-2013 01:00:49 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 29-10-2013 21:21:44 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 30-10-2013 07:54:28 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 2-11-2013 04:58:18 United States #
Handmade Jewelry

Some  genuinely  prime  posts  on this internet site  , bookmarked .

Handmade Jewelry 3-11-2013 06:09:43 United States #
Handmade Jewelry

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

Handmade Jewelry 7-11-2013 04:35:46 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 7-11-2013 15:47:37 United States #
Shera Selvaggi

I love the blog.

Visit Website 12-11-2013 08:20:16 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 12-11-2013 20:14:07 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 6-12-2013 04:06:36 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 7-12-2013 13:44:50 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 20-12-2013 02:05:29 United States #
Claude

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 27-1-2014 15:26:00 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 6-2-2014 05:34:11 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 6-2-2014 16:35:47 United States #
Pamala

You information has been of great help, nice work

AVON Clearskin blemish clearing 7-2-2014 16:49:57 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?

hostingoweseo.org 17-2-2014 16:40:11 United States #
hostingoweseo.org

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 22-2-2014 01:13:11 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 https://vimeo.com/84827976

crystal 23-2-2014 13:06:12 United States #
crystal

Always excellent to discover information that can assist, cheers

crystal 23-2-2014 20:13:55 United States #
crystal

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

Kit 1-3-2014 16:49:09 United States #
Kit

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

Twyla 1-3-2014 18:27:15 United States #
Twyla

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

Deena 4-3-2014 09:03:41 United States #
Deena

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

CHAT 12-3-2014 02:43:32 United States #
CHAT

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

teeth whitening 22-3-2014 06:19:15 United States #
teeth whitening

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

look at more info 2-5-2014 18:41:06 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 09:06:47 United States #
Myrta

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 16-5-2014 03:52:33 United States #
visit

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

Rupert 25-5-2014 08:45:55 United States #
Rupert

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 25-5-2014 22:12:04 United States #
Stanford

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 16-6-2014 22:00:41 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 18-6-2014 12:43:44 United States #
Pantofi Barbatesti

Simply because I at first wrote regarding MBT sneakers at <strong><a href="incaltaminte-mopiel.ro/.../category&path=18_46"; 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 7-4-2015 08:49:55 #
peeter

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 12-4-2015 11:25:02 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 19-4-2015 15:33:57 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 29-4-2015 04:29:14 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 11-5-2015 07:32:56 United States #
Nelly Murff

H Sign workWordPress Article R <a href="www2.facebook.com/.../a>">https://wwwfacebook.com/pages/Tas-Wanita-Murah-Branded-Elegan-Ada-Kw-Korea-Yang-Terbaru/769328163144564</a>

Book of Ra 26-5-2015 19:47:29 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 27-5-2015 16:27:58 United States #
Reva Nate - HR Software

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

Belle Ceo 5-6-2015 04:02:55 United States #
Belle Ceo

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

Nanci Pithan 10-6-2015 04:00:10 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 10-6-2015 20:09:59 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 29-6-2015 05:35:50 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 06:00:16 United States #
Marcelle Nivison

Hii are you interested in some cheap items to xbox and playstation 4, code emailed? Have a nice evening Smile http://idolikecola.dk/1/

Britt Stobbe 18-7-2015 16:03:12 United States #
Britt Stobbe

Read - Tom Watson emotional farewell walk. http://adf.ly/1KztOj

free music downloads 22-7-2015 04:23:43 United States #
free music downloads

free mp3 download site

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

Thanks for the function. Post helped me quite a bit

unique bikinis 28-7-2015 12:33:39 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 28-7-2015 18:39:30 United States #
Agua Bendita Quetzal

agua bendita peru 28-7-2015 19:28:47 United States #
agua bendita peru

swimsuit agua bendita 29-7-2015 12:37:39 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 5-8-2015 18:17:29 United States #
Marco

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 6-8-2015 22:22:23 United States #
agua bendita swimsuit