Oracle Schema Provider using System.Data.OracleClient

ok now. oops, forgot to rebuild the schema provider dll (since it references SchemaExplorer.DLL in the codesmith directory)

received this warning on the build. anyone remedy this already or have a recommendation?

C:\TEMP\OracleNativeSchemaProvider\OracleNativeSchemaProvider.cs(979): 'SchemaExplorer.ViewColumnSchema.ViewColumnSchema(SchemaExplorer.ViewSchema, string, System.Data.DbType, string, int, byte, int, SchemaExplorer.ExtendedProperty[])' is obsolete: 'Please use the constructors that contain the allowDBNull parameter.'

ViewColumnSchema vcs = new ViewColumnSchema(
view ,
reader.GetString(POS_COLUMN_NAME),
GetDbType(reader),
reader.GetString(POS_DATA_TYPE),
GetDBTypeLength(reader),
reader.IsDBNull(POS_DATA_PRECISION) ? (byte)0 : Convert.ToByte( reader[POS_DATA_PRECISION]),
reader.IsDBNull(POS_DATA_SCALE ) ? 0 : Convert.ToInt32( reader[POS_DATA_SCALE] ),
properties);

I was having the same problem as feverts I downloaded the  Unofficial OracleProvider.zip which has a bug evidently...

 gmcelhanon said Unofficial OracleProvider.zip should be updated to the latest version, evidently this never happened

(too bad, cuz that  would have saved me about 4 hours of blindly wondering what I was doing wrong...)

none of these files are dated and posts jump around... how is one supposed to know where the most recent version is? I want latest...

Posting these files in messageboard format makes things difficult for noobs like me...

 frustrating

Any Newer Version Available ?

thanks & regards,

 

The oracle schema provider is working great.

 However, I was tryin' to use the extended properties, but couldn't figure out how to access them from a template.

 For example, I have an authors table in the cmbhs_user schema that I connect to with cmbhs_user login. I can access the table's name and columns ok, but how do I get the following extended property of the authors table. It's the pascal case name "Authors" ?

 insert into cmbhs_user.codesmith_extended_properties
values ('CMBHS_USER', 'AUTHORS', 'TableSchema', 'PascalCaseName', 'Authors', 'System.String')

Is it ?

<%=SourceDatabase.Tables["AUTHORS"].ExtendedProperties["PascalCaseName"].Value %>