Hi guys
I have used strongly typed datasets in vs2005 to create my dal.
I am having an issue that some of my TableAdapters dont have Insert/Delete methods generated. I have tracked this down to the GenerateDBDirectMethods being set to false on those table adpters.
However, If I try and set this to true, I get an error saying “property value is not valid, The type of database object does not allow to set GenerateDBDirect to true”
Now I cant see how these particular datasets are any different to any other in the schema which have this property set to true. They were all created in the same way.
They all use predefined stored procedures for CRUD and all tables have primary keys set.
Can any one help
Thanks
Amit
Cannot set GenerateDBDirectMethods to true in type datasets
torerik
Anyone got any thoughts on this
I have a feeling it maybe a bug in VS
On the datasets where I cant set the property to true, I re configured the datasets to use SQL instead of Stored procedures. I was then able to set the generatedirectdbmethods to true.. then I manualy set the InsertCommand, DeleteCommand etc.. properties back to stored procedures using the properties pane.. and they were able to generate the direct db method.
Is this a bug or am I missing something
Amit
JTC1974
I get this problem also.
I can't change the property any other way.
Jorge P
I have this problem when I use existing stored procedures to configure the table adapter.
I could fix this problem by creating new stored procedures in the table adapter, and after this I return the old stored procedures.