Hi there,
I've been going through the book and I havent had any problems until now and I'm sure I'm doing something wrong.
I try to drag the stored procedure dbo.Getre onto the Genre table in the VS designer however I get the following message
---------------------------
Microsoft Visual Studio
---------------------------
One or more selected database objects return a schema that does not match the schema of the target data class. Nothing has been added to the designer.
---------------------------
OK Help
---------------------------
When I drag it into the "Create Methods in the designer from Server Explorer window the SP loads but I'm told
---------------------------
Unknown Return Type
---------------------------
The return types for the following stored procedures could not be detected. Set the return type for each stored procedure in the Properties window.
dbo.GetGenre
---------------------------
OK
---------------------------
The parameter for the Method is different that the book as instead of it saying (System.Int32 id) it says (id As System.Int32) but I thought this was because I'm using
VB. I try and change the return type and nothing seems to happen but when i run my code I get an error "Invalid object name 'Genre'."
Any ideas - please help, I'm a bit of a newbi