1

Lets consider the following linq statement.

var ctx = new MoviesContext();
var movies = ctx.Movies.AsPagination(pagenum??1, 10);

I have following questions in regards to executing this against Oracle in Entity Framework

  1. For this statement against Oracle, what is the best way for me to see how does the above statement get translated into actual database query?

  2. How do I know if records are being filtered at the database level and I am only going to get the 10 records back in the application memory?

Please let me know.

Thanks

dotnet-practitioner
  • 13,968
  • 36
  • 127
  • 200

1 Answers1

1

You can use a profiler to see what SQL is being executed on the database side of things. This question talks about some Oracle profilers.

Community
  • 1
  • 1
Ocelot20
  • 10,510
  • 11
  • 55
  • 96