Problems with OracleNativeSchemaProvider

Hi everybody,

 I've installed NetTiers 2.2.0 and CodeSmith Professional 4.0 and actually I'm on my way to use them with Oracle CLient 10g through the OracleNativeSchemaProvider, but I've a few problems:

 If I try to use any version of this provider, I get the error from 'MemberColumnSchema' which fix was posted here: http://community.codesmithtools.com/forums/t/497.aspx?PageIndex=3 by " jesuissur".

This error is supposed to be fixed by the zip attached there, which is an update for OracleNativeSchemaProvider.dll and it's config file. But when I copy these two files to my CodeSmith folder overwriting the old ones and restart NetTiers, as I try to select my database from the ChooseSourceDataBase property I get the following error :

Unable to resolve schema provider type name (SchemaExplorer.OracleNativeSchemaProvider, SchemaExplorer.OracleNativeSchemaProvider, Version=1.0.2509.26251, Culture=neutral, PublicKeyToken=null)

I wasn't able to find any other thread with information about this case in the forums...

What could be the reason for that? How could I fix this?

Thanks a lot for the help.

The error is fixed. I've downloaded the latest Schema Provider version posted by flash us here:

Thanks anyway.

Hi obsolete, I've download the lastest version, but still an error. The nettier can not generate file System.Data.SQLite.Procedures.xml in project XXX.Data.GenericClient

Do you have solution? Thanks,

QM 

Hi mhz_bk,

It's not the data provider issue. It's .NetTiers issue. You can make modifications in .NetTiers to generate this file.

I am working on /NetTiers version that can generate Oracle tiers. It still doesn't generate proper web site, but already make data access layer and nunit tests that are mostly passed, all except long fields blob/clob/etc and views. Didn't try it yet for stored procedures.

Hi flash_us,

I known this issue is come from nettier. I try to modify nettier to gen stored procedures xml, but still a trouble. Can you tell me how to modify it? Thanks so much.

Hi mhz_bk,

There are no simple change one line to other. I've make a lot of changes to make it work. Also in the xml which contains queries. But it still not ready.

Hi mhz_bk,

flash_us is right, I have the same problem and it comes from net tiers template, I still don't have any solution...

Hi flash_us,

 Please, let us know if you could finally fix the problem with this xml.

 Thanks both.

Hi obsolete,

The current state of .NetTiers oracle modification:

All the modules are generated exclude webservice layer.

Compilation failed only on the view. Need to comment it manually. I never work with stored procedures, so I can't say anything about it.

NUnit Tests passed for all classes(CRUD operations works fine) excluding entities with the large fields blob/clob/etc + views.

Web site module is generated, needs manual fix in the web.config.

I don't have too much free time now, I'll continue modifications after a month hopefully.

Hi Falsh_us and Obsolete,

Are you guys still working on nettiers to generate accessible Data layer with stored procedures files. or did you guys find any qork around?

 Please update!! 

thanks  

Hi Varshnes,

 Finally, I didn't use CodeSmith because of the problems with the Oracle Provider and I haven't worked with it for long. Sorry.

Maybe Flash_us has better news... Good luck!

 varshnes,

Nothing interesting. The provider actually works fine, all you need is to make changes in the nettiers.

Regards.

Could one of you send me all of the work you have done, I may continue this or find someone to continue this, any work already done would be appreciated.

Thanks

-Blake

I have implemented 'MemberColumnSchema' and Extended Properties in the OracleSchemaProvider. It will be available in the next released version of CodeSmith 5.0.

Thanks