LLBLGen Pro v3.1 Final (Sept 30th 2011) - for .Net 4 Generating EF v4 (Proxy friendly POCO entities) Firebird Client /.Net provider 2.6.5.0

Visual Studio 2010 Premium + sp1

Hi

We are playing with playing with the Firebird EF v4 generation capabilities of LLBLGen and have hit a little snag (meaning battering head against wall!). We have successfully reverse engineered a simple firebird database into LLBLGen (so the provider is correctly configured). We can generate the two projects comprising the EF v4 DAL successfully.

When we load it into VS2010 we get the following error:

Error 40: The Type VarChar is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. C:_TEMPO\Source Code\Persistence\Sfg.edmx 42 6 tmsss.test.firebird.Persistence

I've attached the edmx file (i hope) and the llblgen project can be maade available if needed.

Any thoughts on what I've done wrong or not done?

Regards

Could you please change "VarChar" to "varchar" and see if the problem persists? I want to see if that is a casing issue.

David

Thanks for the response.

I have done as you requested and changed the VarChar to varchar. This does eliminate the error message for those entries.

Extrapolating I tried converting Integer to integer and that doesn't change the error message. Changing Integer to int does

Interestingly there are TimeStamp and Text/Clob entries in the file as well. So perhaps there is a datatype mapping issue rather than a simple casing issue?

I think these are Firebird types. Would you please try referencing the Firebird provider? So the compiler can recognize the types in the generated edmx file.

I have referenced the FirebirdSql.Data.FirebirdClient dll in the generated "persistence" project. This has no effect on the error messages.

I'm new to EF though I've used LLBLGen for many years - is there anything/anywhere in the LLBLGen project or a property in the generated code I need to set? I'm hoping its something simple I've not done (obviously)

So to summarise:

I have ensured that the original firebird db was created using Dialect 3; I regenerated the LLBLGen project, generated code etc. It compiles with the same error. I've added references to the firebird provider dll to the projects with no effect.

So for the sake of completeness I have uploaded the LLBLGen test project I used for information purposes. There might be something in there that you might notice.

Fingers crossed!

I generated code from the attached llblgen project file, compiled the generated projects without referencing any firebird assembly, and they compiled successfully.

Hmmm

Mine still does not work as expected; I need to check some things relating to the ....

Well it looks like my 2010 development environment has managed to get itself really in a twist; I'll re-install another one and see how it goes.

Thanks guys