Hi Rishi,
If you open the snapshot in the ORMProfiler and see the 'Queries, grouped' tab you will see that some queries are repeated with the same parameters over and over again, that's why the warnings. This occurs if, for example you are fetching the same entity in a loop.
For the methods registered in the profiler I assume you are using Adapter, so there is no lazy loading happening.
For instance, you are fetching the Login entity a lot of times with the same parameter (an email address). This could be normal if the calls are in different connections but they all are in the same connection so it seems like you are doing something like:
var adapter = new DataAccessAdapter();
while(...)
{
var someLogin = new LoginEntity();
adapter.FethEntityUsingUniqueConstraint(someLogin, theSameUCFilter);
...
}
In that case, you could fetch the login outside the loop:
var adapter = new DataAccessAdapter();
var someLogin = new LoginEntity();
adapter.FethEntityUsingUniqueConstraint(someLogin, theSameUCFilter);
while(...)
{
...
}
As you are doing some import operations it could be that some repeateable queries are unavoidable. ORMProfiler is saying: "Warning, it looks like you can improve something there."
So you should look into your code to see if you can put some repeatable fetches outside the loop.
