I have another question about my design. I have three datasources (access, excel-files and XML from Web Services) and want to put them together into a mssql database (DBALL). Via GUI a user can update the data if he wants and he can change data as well. I have a construction question and hope I may ask that here. My idea is as follows: Access, Excel and XML data gets imported into an Entity Framework Model (that maps the mssql database). If the user wants to update the database I gonna write the 'new' data from access, excel and XML (via DataReader) into the EF-Model which updates the database. I have almost no experience with this topic and this is a lot of work so I dont want to go the wrong path. Would you recommend this way or are there any backdrafts?
Hi Rick, I try to explain my problem more detailed.
Lets say I have an online/offline questionaire system. On the one hand people fill questionaires online and I can get the data from our provider via web service (they only provide rudimental select (get) functions). On the other hand we get paper questionaires and fill them into an access database. I cannot manipulate the data in there current containers (I cannot reach the database behind the web service). Access and WebService data has to be harmonized since the variables have different names (not all but a lot) in there current state.
I want to set up an sql-server and fill all the data from the two different sources into it and implement an update function to fill in new datasets (e.g. new filled questionaires). I will build an Application (written in .NET) where I can implement different Modules to create graphical/ tabulated Reports or Wordclouds and so on. For some of these reports I need to mark a dataset (questionaire) if it is used in the reports once so I need to write something into the database (some flag or whatever).
So the datastream can be described as follows: Access+WebService -> (via Datareader or own classes HARMONIZATION) -> Entity Framework -> SQL-Server -> Entity Framework -> Application
I am not sure, if this is the best way of doing it since I have no expericence.