Otis,

Some time ago, you mentioned adding support for Pervasive 8. You also mentioned that inner workings are quite similar to SQL Server. Do you have any estimates, if planned at all, for supporting both 8 and 9? If not, than where can I get some guidelines or tips on how to generate templates for those myself?

Thanks in advance

It's not just templates: a driver and DQE also has to be created. Pervasive was on our list, but there was one problem with pervasive: it was very hard to get the meta data out of the database. (read: for some things: impossible). I therefore put it on ice.

I see. Now, would it be possible to create equivalent database in SQL Server, create LLBL stuff, and than do some search and replace to make it use Pervasive database and Pervasive .net provider instead. That way, there'd be no need to dig into the meta data. Of course, assuming that nothing specific to Pervasive is used.

Kowalsky wrote:

I see. Now, would it be possible to create equivalent database in SQL Server, create LLBL stuff, and than do some search and replace to make it use Pervasive database and Pervasive .net provider instead. That way, there'd be no need to dig into the meta data. Of course, assuming that nothing specific to Pervasive is used.

The DQE for Sqlserver has to be adjusted to work with the pervasive .NET provider as well, creating PervasiveCommand etc. objects, instead of teh SqlClient objects. The SqlServer DQE sourcecode is in the sourcecode folder in the llblgen pro installation folder. It's pretty straightforward.

In the generated code, you have to alter the SqlDbType enum specifications for field persistence info (selfservicing: EntityFieldFactory.cs/vb, Adapter: persistenceinfofactory.cs/vb) to meet the pervasive types.

Thanks for the instructions - I'll give it a try and let you know if I get lost. :-)

On the other hand, Pervasive had a major release of their ADO.NET provider on October 13, 2005: http://www.pervasive.com/developerzone/access_methods/adonet.asp This provider supports both 8.7 and 9.1 version of their RDBMS. Would you be kind and check whether all those problems you described have been fixed. If I'm lucky, they are, which would allow you to include a full support for it in LLBLGen. I think it's worth a try. Please let me know if you have time to do this and when.

Much appreciated.

The problems I had was with the metadata availability inside pervasive , not with the provider.