Read and write object data to SQL Server Database

[Anonymous]

Hi everybody
Does anyone have experience in read and write object data to SQL Server? Is the data transfer rate and regeneration drawings is good? I heard that with FDO in Autodesk map it can be done. Data is written in the Geodatabase format. Is FDO can be used in AutoCAD? Is there a similar Geodatabase format in AutoCAD?
thanks,

[norman.yuan]

Object Data is AutoCAD MAP 3d (and Civil 3d) feature. If you are talking about plain AutoCAD, no, you cannot access Object Data, even you know the drawing file contains Object Data. The same applies to FDO, in general (well, you can sort of programming FDO with plain AutoCAD, but it hardly makes sense).

Also Object Data has nothing to do with regenerating drawing.As for read/write data from/to Sql server with Object Data, (in AutoCAD MAP), it depends on what the SQL DB is: generic DB, or spatial DB...

[OysteinW]

We use FDO providers for SQL Server and Oracle to read and write our custom AutoCAD entities (Land use planning) to FDO features in an external database. The features are stored in a customized schema created with the same API. (we use the .NET version of the API). 

The performance is OK.

The FDO API can be plugged into standard AutoCAD if you distribute all the necessary FDO components, but it's easier to go with AutoCAD Map3d or Civil3d as the API is ready for use straight out of the box.