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

Do you want to upload or download?

UPLOAD.

As far as I know, you may create a folder under svn /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.

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

Regards, Carlo

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 . 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.

Thanks for making this driver, Carlo!

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 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

Regards, Carlo

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 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

Regards, Carlo

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

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

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

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

It's still in the repository at

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

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

Yes sure.

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

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

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.

Thanks Otis,

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

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

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

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.

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

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.

Thanks for the fast reply Otis!

I hope you can find it...

Kind regards TomV

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.

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"

Kind regards TomV

TomV wrote:

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

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

Kindly regards, Carlo

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