I am using a TableAdapter in an ASP .NET application (C#) that does a couple of standard queries, namely a GetAll, Create, Update, Delete, GetByID.
The problem I am having is a very strange one.
When I run the GetAll function, data is returned fine and the SQL statement shows under SQL Profiler.
However, when I run the Create, Update or GetByID methods, I get data fine, but the Insert,Update or Select statmenet does NOT appear under SQL Profiler.
Why is this? Data is being retrieved without hassle - but when I want to go to SQL Profiler to view the query that was executed, nothing displays. The only time it ever displays is when the GetAll() query executes.