Hi,
We have a problem with LLBLGen generated code.
Generated code for development database is working without any problem. But when we deploy the application in UAT region we got some issues. The most related problem can be different schemas in development and UAT regions.
Our Oracle schema in UAT region is not the same as the development one.
Specially when I want to save a new entity containing an Identity field, I get an error "Sequence not found" in my UAT environment.
When looking in the class PersistenceInfoProvider.cs, it appears that some methods are created with the schema hard-coded for the sequence.
For example :
private void InitScAgegroupsEntityMappings()
{
base.AddElementMapping( "ScAgegroupsEntity", "AspWepAppsORC", @"SWDCADM", "SC_AGEGROUPS", 8 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Agegroupsid", "AGEGROUPSID", false, (int)OracleDbType.Decimal, 22, 0, 38, true, "SWDCADM.SC_AGEGROUPS_SEQ", null, typeof(System.Decimal), 0 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Agegroupsname", "AGEGROUPSNAME", true, (int)OracleDbType.Varchar2, 255, 0, 0, false, "", null, typeof(System.String), 1 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Agefrom", "AGEFROM", true, (int)OracleDbType.Decimal, 22, 0, 38, false, "", null, typeof(System.Decimal), 2 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Ageto", "AGETO", true, (int)OracleDbType.Decimal, 22, 0, 38, false, "", null, typeof(System.Decimal), 3 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Displayorder", "DISPLAYORDER", true, (int)OracleDbType.Decimal, 22, 0, 38, false, "", null, typeof(System.Decimal), 4 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Lastmodified", "LASTMODIFIED", true, (int)OracleDbType.TimeStamp, 11, 9, 0, false, "", null, typeof(System.DateTime), 5 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Modifiedby", "MODIFIEDBY", true, (int)OracleDbType.Varchar2, 255, 0, 0, false, "", null, typeof(System.String), 6 );
base.AddElementFieldMapping( "ScAgegroupsEntity", "Activeagegroups", "ACTIVEAGEGROUPS", true, (int)OracleDbType.Char, 1, 0, 0, false, "", null, typeof(System.String), 7 );
}
Could you please instruct us to generate schema independent code , which we can use to access any database schema.
Our Versions
LLBLGen Pro Version : 2.6 Final
.Net Framework : 3.5
Oracle :10g
Thanks a lot.
Niluka Marasinghe
