How to Generate an Entity Model for MSSQL 2005 ?

Discovery · Post by **Discovery** » Mon 28 Sep 2009 11:12

The Entity Developer seems to be developing Entity Models based on MSSQL 2008.
(We are getting references to datetime2, which is a function added to MSSQL 2008)

I've looked through the designer, but cannot see anything to select the target SQL Server. (ie. MSSQL 2005)

AndreyR · Post by **AndreyR** » Mon 28 Sep 2009 14:02

Entity Developer for dotConnects does not support SQL Server models.
You can download a trial version of Entity Developer for SQL Server here:
http://www.devart.com/entitydeveloper/download.html

Discovery · Post by **Discovery** » Mon 28 Sep 2009 16:18

I am already using the trial, which is why I am reporting the faults I have found.

Looking at the .edml file I have generated, the ProviderManifestToken is set to 2008. Changing it to 2005 makes it work nicely with SQL Server 2005.

I would say, that you need some way of setting that value in the Entity Developer, rather than having to manually edit it.

(Sorry if I sound like a moaner, but I really like this product and need to get Management to like it as well)

AndreyR · Post by **AndreyR** » Tue 29 Sep 2009 07:44

Thank you for the report, we appreciate your feedback.
Feel free to contact us.
We will implement the proper ProviderManifestToken changing in one of the nearest builds. I will post here as soon as it is avaiable.

AndreyR · Post by **AndreyR** » Wed 28 Oct 2009 15:02

We have implemented this behaviour in the upcoming Beta build of Enity Developer.

AndreyR · Post by **AndreyR** » Mon 02 Nov 2009 08:48

The problem is fixed in the latest Beta build of Entity Developer.