I have a Microsoft Access 2010 database (*). Now, using Visual Studio 2010, I want to create a WPF application and add the database as a data source. The application will have a window with a frame that provides page navigation. There are no problems so far. But:
- What is the correct way to create a database in this scenario? Only tables? Or is everything on demand? (VS2010 talks about the views I assume (?) Are queries)
-Data data must be updatable and records can be added. Some relationships go through reference tables (many-to-many), and there are relationships with a null foreign key. Do I have to take steps manually to make it work?
-When adding the VS2010 data source created xsd from my Access database. I think xsd may need to further configure the application to work properly. What if I change the design of the Access database, I will also have to restore xsd again. Is this correct, and is it usually done this way? OR, should I let the source Access database go over and give the application the ability to create new empty databases?
-How do you provide controls on a page for writing records to a table? Is there any special database control?
- How (WPF class?) To load records in the data context that is displayed on the page? (At this level, it probably doesn't matter what type of data source it has.)
(*) Database with one user desktop