A
A.T
I have a typed dataset. It has a single datatable. I used the wizard in
VS.Net 2005 to generate it. It is setup to do a Select from a database view
in SQL Server. The view in question is updateable as it has an instead of
trigger attached. But GenerateDbDirectMethods of true throws an error saying
"The type of the database object does not allow to set GenerateDBDirect to
true."
Now I can understand why because it must look at the view SQL and see joins
and assume its not updateable but we handle all that through triggers. If I
can get the TableAdapter to generate my Update and Delete command it will
work but the designer refuses to do that or allow me to override it's
assumption that it's readonly. Has anyone else hit this problem? What is the
work around?
VS.Net 2005 to generate it. It is setup to do a Select from a database view
in SQL Server. The view in question is updateable as it has an instead of
trigger attached. But GenerateDbDirectMethods of true throws an error saying
"The type of the database object does not allow to set GenerateDBDirect to
true."
Now I can understand why because it must look at the view SQL and see joins
and assume its not updateable but we handle all that through triggers. If I
can get the TableAdapter to generate my Update and Delete command it will
work but the designer refuses to do that or allow me to override it's
assumption that it's readonly. Has anyone else hit this problem? What is the
work around?