C# Database Access Synchronisation

My client is looking to build a desktop application for property sales. It will be used by sales people in the field who are viewing potential properties which they will rate (i.e. for the purpose of possibly buying and reselling). I need a programmer with the following skills: * C# * Access and SQL Server ([login to view URL]) * Winform? * Multi-threading experience * NUnit * Resharper **PLEASE READ THE REQUIREMENTS BELOW FOR FULL DETAILS** ## Deliverables My client is looking to build a desktop application for property sales. It will be used by sales people in the field who are viewing potential properties which they will rate (i.e. for the purpose of possibly buying and reselling). The application will have a central SQL Server database and will be accessed by the windows forms client application (that we are building). Because the sales people may not have an internet or network connection, we will need to store a local copy of the database (using MS-Access) and then synchronise the server and local databases once an internet connection is re-established. When the application opens, it should use the MS-Access database for showing data on the screens and reports. In addition, the program should use a background thread (or threads) to synchronise the local database and server database. Although the databaes have not been designed yet, I am hoping that the structure of the two databases will be the same (or at least very similiar). I need a programmer with the following skills: * C# * Access and SQL Server ([login to view URL]) * Winform? * Multi-threading experience * NUnit * Resharper I am looking for a developer who delivers quality software that is well tested. You will be expected to provide NUnit test cases for ALL the classes that you develop. I also expect that most of the classes you deliver will come with interfaces. In total, there will be about 20-25 tables (maximum) that will need to be synchronised. I will write 1 class that will synchronise 1 server table with 1 client table. Your task will be to write C# classes that will be bases on? that template and will? be? used to do the following ? 1) Bring down new records from the server database to MS-Access ? 2) Where applicable bring changes to records on the MS-Access database to the server database (most of the data will be readonly and therefore will not have to be sent back to the server) ? 3) Come with NUnit test cases (that do not require an actual database for running tests). Test coverage should be very high without running the actual SQL. ? 4) Be well commented (using GhostDoc and meaningful comments where applicable) ? 5) The code should be run through Resharper to ensure it is high quality ? 6) All classes should use interfaces which will help us to write unit tests ? 7) All classes should be thread safe ? 8) All classes should be robust and use good programming practices like error handling, guarding against nulls, and so on ? 9) The classes / program should be able to cope with data collisions whereby 2 sales people updated the same record while offline. When they go to synchornise, obviously only 1 update will be able to make it. We'll need to report on changes that were not synchronised correctly. 10) If selected, you would be expected to send some of the developed code to me early in the project so that I can review before all the code is delivered. To be considered please do the following 1) To ensure you have read this, send 'Gorilla' in the first sentence of your response. 2) Send me one or two lines which show that you understand what is required 3) Tell me what commercial Winform grids you have used (just send me the names of the vendors / compoanies that wrote them) 4) Send me a word document with 2 or 3 screenshots of an application that you have built and explain a little about what it does 5) Answer this question: If I have a form that creates a new thread and that thread update a label on the form what will happen? 6) Send me some sample code that you wrote which is used to update a table in a database. I don't care what the database is ... I just want to review the code. I will be making a selection in the next 10 days. I should have more details on the database by then so we would both confirm the scope of the project. However, I do not see it involving more then synchronising 20-25 tables from SQL to Access and about 5-10 tables from Access to SQL. If things work out well, there may be a 2nd phase to the project whereby you will help write some of the screens and some of the reports. Good luck! Liam.