To do such a thing i have done the followings :
- Creating temporary tables on Navision SQL database.
- Creating a dbml schema from the need tables in the SQL database of Navision. Theses represent Linq to SQl classes. (great tutorial about using Linq to SQL)
- Creating a generic repository to use the Linq to SQL generated classes to do CRUD operations and search. (Code for Generic Repository)
- Installing Navision NAS (Tutorial about NAS)
- Developing NAS application to synchronize the temporary tables with the real ones on Navision.