muro
Active member
- Joined
- Apr 30, 2018
- Messages
- 26
- Programming Experience
- 3-5
Dear friends,
when i change things in my sql database, for example i add a new column, delete one, change datatype of a column and stuff like that and then update my dataset with the wizard the changes are not shown correctly. Some things are updated correctly some not and only if i delete the datatable from the dataset.xsd and add it again (with the datasource update wizard) it is shown correctly. The problem is i have added so many queries on my datatable in the dataset xsd , and then i need to write them all manualy again since they are also deleted with the table. so how to update the dataset.xsd and apply all new changes from database, correctly, so it matches the table in the database?
I tested entitiy framework and the changes from the db are shown correctly in the enitity model, but i dont want to use entitiy since there are alof of things i don´t know.
when i change things in my sql database, for example i add a new column, delete one, change datatype of a column and stuff like that and then update my dataset with the wizard the changes are not shown correctly. Some things are updated correctly some not and only if i delete the datatable from the dataset.xsd and add it again (with the datasource update wizard) it is shown correctly. The problem is i have added so many queries on my datatable in the dataset xsd , and then i need to write them all manualy again since they are also deleted with the table. so how to update the dataset.xsd and apply all new changes from database, correctly, so it matches the table in the database?
I tested entitiy framework and the changes from the db are shown correctly in the enitity model, but i dont want to use entitiy since there are alof of things i don´t know.