Hi,

I've been digging through the Manifold documentation for some time now but still things aren't clear to me. So I hope that someone can give me an explanation. What I want to do is to export geometry to a Sql Server table from within an Asp.Net application. The problem is, that for each geometry I have to insert a record in two tables, one holding the geography data and one holding some meta data.

Unfortunatly I don't understand how to use ExportSqlServer object. Is there a way to specify what INSERT statement should be executed on export? How does ExportSqlServer deal with SqlServer's spatial columns (can I specify if the column's datatype is Geometry or Geography)?

Any help is kindly appreciated.

Best regards, Frank

Have you checked the Application Object in Manifold Help->Application ?

Geography you only have in SQLServer2008...

And have a look in Help "SQL Server Spatial DBMS Facilities"

Important for you:

"Note that Manifold can import or link a drawing from either SQL Server native GEOMETRY or GEOGRAPHY but that exports from Manifold will always be exported into SQL Server native GEOMETRY. Exports are not available into SQL Server GEOGRAPHY."

So it`s not possible to use the ExportSqlServer with Geography only

Geom NewGeom(GeomType type)

Creates new geometric entity of given type.

So i think but i am not an expert in this things...