long id

[juan_gandhi]

I think I got it where all this bs about passing around numerical ids of entities instead of entity references (maybe lazy) come from. It's like 'error code'. It comes from the ancient c programming, where we just could not allocate a string for a readable piece of text, or for the data that may need some efforts to instantiate or allocate.

In short. It's stupid to pass around "ids" in a program.

Comments

[yatur.livejournal.com]

> Weird idea to issue 10k queries for retrieving 10k records.

Would do you mean "weird idea"? That's how lazy references work. Be careful what you are wishing for :)


var auditRecords = myLog.GetAudit(); // gets 10K audit records

foreach (var record in auditRecords) // loops 10K times
{
var user = record.User; // a lazy reference
if (user.IsAdmin) ... // causes "user" to be instantiated from DB via query
}


[juan-gandhi.livejournal.com]

Right. It is an interesting problem. Not that a hard-coded ad-hoc solution is an answer.