Foxpro Driver for LLBLGEN v2.0

Posts   
1  /  2
 
    
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 14-Mar-2007 09:44:18   

Where can I upload the new Driver, DQE and template files for LLBLGEN v2.0?

I see only the repository for v1.0.2005.1.

Regards, Carlo

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 14-Mar-2007 13:26:31   

Do you want to upload or download?

Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 14-Mar-2007 13:51:54   

UPLOAD.

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 14-Mar-2007 14:14:35   

As far as I know, you may create a folder under svndisappointed /www.sd.nl/LLBLGenPro/CustomDrivers/

Say you call it "v.2.0" where you can upload your work. If you don't have permission to Upload, or to create a folder, please send an e-mail to support AT llblgen DOT com with your CustomerID.

Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 14-Mar-2007 14:45:55   

Ok, I have the permissions to create the necessary folders.

I will upload the files today to /CustomDrivers/FoxPro/v2.0. I have also renamed the folder Carlo to v1.0.2005.1, now it is clear, for which version the files are smile

Regards, Carlo

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 15-Mar-2007 06:14:06   

I'm currently in Seattle, US, so I can't access the server with the repository right now, I will be able to do that within a couple of days, so I'll then make sure everything is in the right folder simple_smile . You can just check in into the folder you want and I'll make sure the stuff is moved into the right folder if it has to. simple_smile

Thanks for making this driver, Carlo! smile

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 15-Mar-2007 09:00:42   

I'm currently in Seattle, US

That is pretty cool. If you have some spare time, please buy an original seattle mariners baseballcap for me sunglasses One size fits all, I don´t know what size my head is - there is a lot of stuff in it - and that need space smile

Regards, Carlo

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 16-Mar-2007 10:17:03   

Rushmore wrote:

I'm currently in Seattle, US

That is pretty cool. If you have some spare time, please buy an original seattle mariners baseballcap for me sunglasses One size fits all, I don´t know what size my head is - there is a lot of stuff in it - and that need space smile

Regards, Carlo

Too late, I'm already back again simple_smile Sorry, Carlo.

Frans Bouma | Lead developer LLBLGen Pro
Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 16-Mar-2007 11:58:36   

I can live with that (I hope) ...

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 17-Mar-2007 16:47:54   

simple_smile

I think the files you've checked in are at the right spot! Thanks a lot for this work! smile

Frans Bouma | Lead developer LLBLGen Pro
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 26-Mar-2008 10:30:40   

Hi,

We work on SQL Server, but for a very urgent client project with legacy code I need to access some FoxPro tables. So it would be a life saver if I could download the FoxPro driver today. The deadline is the end of the week...

Waiting for some more information...

Kind regards TomV

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 26-Mar-2008 11:14:40   

It's still in the repository at

svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 26-Mar-2008 11:17:46   

Walaa wrote:

It's still in the repository at

svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0

Thanks. Does this mean that I'm allowed to get the code, build everything and use it?

Kind regards, TomV

Walaa avatar
Walaa
Support Team
Posts: 14946
Joined: 21-Aug-2005
# Posted on: 26-Mar-2008 11:23:23   

Yes sure.

TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 26-Mar-2008 11:44:12   

Thanks Walaa,

I downloaded the code, copied the files within the installation directory of LLBLGenPro and tryied it out. But I get some errors. Maybe it's not finished yet?

The first part for the Adapter way of working is good as far I can see, but the DBSpecific code doesn't get generated. I get some errors. Looks like I miss the SD.TemplateBindingsFile like there is for SQL Server: SD.TemplateBindings.SqlServerSpecific.NET20.templatebindings.

Any idea where I might find it? Or I'm looking over it cry


Generator process results
Task execution log.
    Task group: SD.Presets.Adapter.General2005
        Task group: SD.Tasks.Adapter.DatabaseGeneric
            Task: SD.Tasks.Adapter.DbGenericProjectDirectoryCreator
            Task group: SD.Tasks.Generic.DirectoryCreators
                Task: SD.Tasks.Generic.EntityClassesDirectoryCreator
                Task: SD.Tasks.Generic.FactoryClassesDirectoryCreator
                Task: SD.Tasks.Generic.HelperClassesDirectoryCreator
                Task: SD.Tasks.Generic.RelationClassesDirectoryCreator
                Task: SD.Tasks.Generic.TypedListClassesDirectoryCreator
                Task: SD.Tasks.Generic.TypedViewClassesDirectoryCreator
                Task: SD.Tasks.Generic.ValidatorClassesDirectoryCreator
            Task: SD.Tasks.Adapter.EntityCollectionClassGenerator
            Task: SD.Tasks.Generic.ConstantsEnumsFileGenerator
            Task: SD.Tasks.Generic.AssemblyInfoFileGenerator
            Task: SD.Tasks.Generic.FieldInfoProviderClassGenerator
            Task: SD.Tasks.Generic.TypeDefaultValueClassGenerator
            Task: SD.Tasks.Generic.InheritanceInfoProviderClassGenerator
            Task: SD.Tasks.Generic.EntityRelationsClassGenerator
            Task: SD.Tasks.Adapter.CommonBaseClassGenerator
            Task: SD.Tasks.Generic.EntityClassesGenerator
            Task: SD.Tasks.Generic.EntityFactoryClassesGenerator
            Task: SD.Tasks.Generic.EntityFieldFactoryClassGenerator
            Task: SD.Tasks.Generic.EntityFieldsFactoryClassGenerator
            Task: SD.Tasks.Generic.ResultsetFieldsClassGenerator
            Task: SD.Tasks.Generic.FieldCreationClassesGenerator
            Task: SD.Tasks.Generic.TypedListClassGenerator
            Task: SD.Tasks.Generic.TypedViewClassGenerator
            Task: SD.Tasks.Adapter.VsNetDbGenericProjectFileCreator
        Task group: SD.Tasks.Adapter.DatabaseSpecific
            Task: SD.Tasks.Adapter.DbSpecificProjectDirectoryCreator
            Task: SD.Tasks.Generic.AssemblyInfoFileGenerator
            Task: SD.Tasks.Generic.AppConfigFileGenerator
            Task: SD.Tasks.Generic.PersistenceInfoProviderClassGenerator
                    Could not find template 'SD_PersistenceInfoProviderAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Adapter.DataAccessAdapterClassGenerator
                    Could not find template 'SD_DataAccessAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Adapter.VsNetDbSpecificProjectFileCreator
                    Could not find template 'SD_VsNet2005DBSpecificAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Generic.ActionProceduresClassGenerator
                    Could not find template 'SD_ActionProceduresAdapterTemplate'. It is not defined in the templatebindings or is empty.
            Task: SD.Tasks.Generic.RetrievalProceduresClassGenerator
                    Could not find template 'SD_RetrievalProceduresAdapterTemplate'. It is not defined in the templatebindings or is empty.
        Task group: SD.Tasks.Adapter.Webservices.SchemaImporter

Anyway, thumbs up for Rushmore!! Nice to write this interface and it's even more nice to share this with us!

Kind regards Tomv

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 26-Mar-2008 13:23:58   

You've to create a templatebindings file, similar to the sqlserver one, place it in the templates folder and make sure the file paths point to the foxpro templates.

Frans Bouma | Lead developer LLBLGen Pro
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 26-Mar-2008 13:42:42   

Thanks Otis,

I created the templatebinding for C# and I get less errors smile

But I still get errors for the action and retrievel templates. These were missing from the code I downloaded from SVN. Probably I'm doing something wrong, again confused

Are these missing templates (available in SQL Server, ...) just missing or not needed for FoxPro (maybe related to stored procedures, etc...). I hope the second one.

Although the generated code seems to work. So I presume... Now I'm having some reference problems. I have bought 2.5 and Visual Studio 2008 is complaining I should use a dll with version 2.0


The type 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null'.

Kind regards, TomV

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 26-Mar-2008 13:54:38   

The templates are for v2.0. So you've reference the 2.5 runtime lib in your vs.net project. THe proc templates aren't needed, as foxpro doesn't have procs. (to my knowledge).

Perhaps the templates need some adjustments here and there, not sure.

Frans Bouma | Lead developer LLBLGen Pro
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 27-Mar-2008 09:32:21   

Hi Otis,

Still busy getting this working... I get reference problems... Because you told me the templates are for v2.0, I downloaded this version and created a new project, regenerated the code, but I still get 1 error on the following method...


/// <summary>
/// Creates a new Dynamic Query engine object and passes in the defined catalog/schema overwrite hashtables.
/// </summary>
protected override DynamicQueryEngineBase CreateDynamicQueryEngine()
{
    DynamicQueryEngine toReturn = new DynamicQueryEngine();
    return (DynamicQueryEngineBase)toReturn;
}

The error messages are (I think the second one is linked to the first one):


The type 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null'.

And the following


Cannot convert type 'SD.LLBLGen.Pro.DQE.Foxpro.DynamicQueryEngine' to 'SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase'

The strange part is that I actually have referenced the SD.LLBLGen.Pro.ORMSupportClasses.NET20, Version=2.0.0.0?

Can you please help me one more time, deadline is getting close now...

Kind regards TomV

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 27-Mar-2008 09:53:38   

I think I see what happened.

The v2.0 version of the DQE has no source but is in subversion with just the dll. It is compiled against the ormsupportclasses sourcecode without a signature (publickey = null).

we didn't know the DQE was there just with the dll, it should have been source only. I'll see if I can get the DQE of 1.0.2005.1 compiled against the v2.0 ORMSupportclassses and will upload that source in the v2.0 branch.

Frans Bouma | Lead developer LLBLGen Pro
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 27-Mar-2008 09:55:58   

Thanks for the fast reply Otis!

I hope you can find it...

Kind regards TomV

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 27-Mar-2008 10:02:18   

I've ported the code to v2.0:

svn://www.sd.nl/LLBLGenPro/CustomDrivers/FoxPro/v2.0/DQE

I don't have access to a foxpro db so it's not tested, but it compiled.

I've removed the binary files from svn. the v2.0 versions were ports from the 1.0 ones anyway.

Frans Bouma | Lead developer LLBLGen Pro
TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 27-Mar-2008 11:04:28   

Super! It works!

Thanks a lot Otis to help me out on this one!

And also one more time, thanks to Rushmore to give this code to the "LLBLGen community" smile

Kind regards TomV

Rushmore
User
Posts: 125
Joined: 27-Jan-2005
# Posted on: 27-Mar-2008 13:31:39   

TomV wrote:

Super! It works! And also one more time, thanks to Rushmore to give this code to the "LLBLGen community" smile

There are some other issues with the Databasedriver too. Take care about the settings of decimal columns. I haven´t uploaded the ported source to the repository, because there are some known issues to solve. They depends on the DBDriver and the DQE.

I will upload the sources and modified templates if I have a really stable, tested and smooth running version smile

Kindly regards, Carlo

TomV
User
Posts: 76
Joined: 31-Jan-2008
# Posted on: 27-Mar-2008 13:33:39   

Thanks Rushmore,

Any idea when this will be? For now I only need simple queries and a single delete statement. So I hope it will work for now...

I'll keep following this thread...

Kind regards TomV

1  /  2