Oracle aliases limit

[Dolfik1]

Oracle has limits to alias name. This limit is 30 characters.

Is possible to add support short name to alias? For example:

MyTable_Items_Msnt_Id
MyTable_Items_Msnt_Name

During the mapping replace MyTable_Items_Msnt_ to MyTable_Items_UnitOfMeasurement.

[lingster]

I've faced similar issues. The oracle limit is raised to 128 bytes from Oracle 12.2 version onwards. Maybe this could be a temp workaround?

[Dolfik1]

I wrote this class for use short names:
https://gist.github.com/Dolfik1/78aa88a93d5197de41e0fa9afa28c316

Example of usage:

var data = Db.Query<dynamic>(query, new { idChanges });

var abbrs = new Dictionary<string, string>();
abbrs.Add("MaterialGroup_Ums", "MaterialGroup_UnitOfMeasurement");
abbrs.Add("Pressure_Ums", "Pressure_UnitOfMeasurement");
data = Abbreviations.Rename(data, abbrs);

This class will renames MaterialGroup_Ums to MaterialGroup_UnitOfMeasurement