I have an WPF application with LLBLGen DAL(Self servicing) as DLL as Data Access Layer. We are using Oracle 11g as database. The new requirement is that the application will also able to connect to local oracle database(standard edition) which is to be installed with all the user machines (if the network is not available). The structure of both local and central database will be same. But we are using the Oracle sequnce numbers for Primary key fields. So is it possible to sync both the database?
if it is not possible we can design few methods which will upload the newly created records from the local database to the central database. In this case how shall I access both database in my application?