none
LINQ to SQL Designer and SQL Server 2008 "geography" Data Type RRS feed

  • Question

  • Dear NG,

    I'm using SQL Server 2008 with AdventureWorks2008 as Database.

    When I want to drag the Person.Address Table on the designer surface my Visual Studio 2008 showing me following error message:
    One or more selected items contain a data type that is not supported by the designer.

    I think, it is the geography column in Address Table.

    How can I solve this problem? SP 1 for Visual Studio 2008 is already installed.

    Best,
    Ozgur Aytekin
    Tuesday, August 26, 2008 11:13 AM

Answers

  • A number of SQL Server features are not supported by LINQ to SQL even with SP1 installed - this includes geography and hierarchy types.

    [)amien
    Tuesday, August 26, 2008 4:28 PM
    Moderator

All replies

  • A number of SQL Server features are not supported by LINQ to SQL even with SP1 installed - this includes geography and hierarchy types.

    [)amien
    Tuesday, August 26, 2008 4:28 PM
    Moderator
  • Hi Damien

    Is there any plans for supporting all sql 2k8 data types?

    best,
    Ozgur
    Tuesday, August 26, 2008 8:53 PM
  • Supporting the missing types are on our list of features we'd like to add to the next release but I can't confirm what will make it at this point in time Sad

    [)amien
    Wednesday, August 27, 2008 2:53 AM
    Moderator
  • Please work on supporting the SQL 2008 data types Geometry and Geography in the LINQ Visual Studio 2008 designer.......

     

    Brgrds,

    Bjørn Sigurd Johansen,

    Norway

     

    Monday, November 17, 2008 11:22 AM
  • Please work on supporting the SQL 2008 data types Geometry and Geography in the LINQ Visual Studio 2008 designer.......

    Joe
    Autralia
    Tuesday, May 12, 2009 5:51 AM
  • Please work on supporting the SQL 2008 data types Geometry and Geography in the LINQ Visual Studio 2008 designer.......

    Kirk
    USA
    Friday, May 15, 2009 7:07 PM
  • Please work on supporting the SQL 2008 data types Geometry and Geography in the LINQ Visual Studio 2008 designer.......

    Matias
    Argentina
    Tuesday, June 23, 2009 12:18 PM
  • Please do
    thanks!!!
    Sunday, July 5, 2009 1:05 PM
  • Simple answer, store the data as Xml in the Database. In C# Make sure to use SqlGeography as your Type, when inserting the data call .AsGml().Value to get the Xml. Pass in the Gml as the Linq Xml. Now when querying call

    geography

     

     

    ::GeomFromGml()
    • Proposed as answer by Martin_Xie Friday, April 16, 2010 4:30 AM
    Sunday, October 11, 2009 7:37 AM
  • Please work on supporting the SQL 2008 data types Geometry and Geography in the LINQ Visual Studio 2008 designer.......

     

    Brian 

    USA


    Friday, July 1, 2011 1:41 PM