VS2005 or VS2003 for NPGSQL

Posts   
 
    
Pav
User
Posts: 6
Joined: 15-Apr-2006
# Posted on: 10-Aug-2006 05:16:57   

Do I need VS2005 to run LLBLGEN Ver 2.0 with PostreSQL 8.1 and Npgsql or should I be able do run with VS2003.

I am getting a runtime error with the demo version of LLBLGEN when trying to retrieve data.

System.IO.FileLoadException: The located assembly's manifest definition with name 'Npgsql' does not match the assembly reference.

I am using the Npgsql that came with the PostreSQL Install and I am pretty sure its for .net1.1 . It's ver 0.7.0.0. I cant use the version the came with the LLBLGEN demo, VS2003 refuses to accept it as a reference.

My Target Platform is .net1.1 . No Compile Errors, just the runtime error. I had .net 2.0 also installed.

Does anybody know if I must have VS2005, to run with PostgreSQL and Npgsql with LLBLGEN Pro?

Pav

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 10-Aug-2006 06:08:08   

Generaly you can use LLBLGen Pro v.2 to generate projects that target dotNet Framework 2 (VS 2005), dotNet Framework 1.1 (VS 2003) and/or dotNet Framework 1.

Required for PostgreSql: the Npgsql provider, available at the PostgreSql website. LLBLGen Pro comes with the Npgsql .NET provider dll for .NET 2.0 as the Npgsql provider doesn't install itself in the GAC. To use the generated code in your own project, be sure to either download the latest Npgsql .NET provider for .NET 1.x or .NET 2.0, depending on the target platform of your code.

I cant use the version the came with the LLBLGEN demo, VS2003 refuses to accept it as a reference.

That's because it's a .NET 2.0 dll.

I am getting a runtime error with the demo version of LLBLGEN when trying to retrieve data.

System.IO.FileLoadException: The located assembly's manifest definition with name 'Npgsql' does not match the assembly reference.

Please make sure the application does reference the latest version of Npgsql version available. (remove and re-add the project reference)

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 10-Aug-2006 09:08:44   

the version that comes with postgresql is pretty old. Use the rc1 from the npgsql website simple_smile

Frans Bouma | Lead developer LLBLGen Pro
Pav
User
Posts: 6
Joined: 15-Apr-2006
# Posted on: 11-Aug-2006 02:49:17   

I cant get it to work.

I've tried RC1 and RC2 and used GACUTIL to remove any reference in the GAC of the older versions.

Even replaced the version supplied with llblgen with RC1 for net1.1 because you have some sort of file exist validation and repository restore on the demo startup.

I am still getting the same error but now its crashing in a different spot.

I guess I'll check into upgrading to VS2005.

Thanks

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 11-Aug-2006 10:19:59   

The designer comes with the NPGSQL RC1 dlls in the postgresql driver folder, so it should work in the designer without a problem. (no GAC install needed, please don't move these dlls to the GAC)

I find it strange that it doesn't work with your install.. You dont need vs.net 2005, llblgen pro doesn't rely on vs.net.

Frans Bouma | Lead developer LLBLGen Pro