Click here to Skip to main content
15,434,147 members

Comments by hoernchenmeister (Top 122 by date)

hoernchenmeister 15-Jun-18 7:09am View    
Thanks for posting this. It is indeed a bouquet of interesting things. This might take me a while to go through it, but I am looking forward to it.
hoernchenmeister 15-Jun-18 7:08am View     CRLF
Thanks a lot for your contribution. It is very much appreciated!
hoernchenmeister 10-Jun-14 10:35am View     CRLF
Thanks Peter for your answer. Yes, you are right, these dll's are also installed in the GAC. But I did so with all versions before (removing the old one and adding the new one). That's where I am confused right now, because I really believe it worked like that before... All the projects that I own always reference the folder mentioned above and never the GAC... Best regards Andy
hoernchenmeister 8-Apr-14 2:39am View     CRLF
I checked the query using the SQL Analyzer tool and it creates a query like this when I use FirstOrDefault: SELECT TOP 1 * FROM tblEmailPostbox WHERE id = @id ...so I assume that's all right. ObjectSet does not contain records, it just represents the table object to query from. Anyway Maarten, I really appreciate your help on this one. Thanks a lot! Cheers Andy
hoernchenmeister 7-Apr-14 9:25am View     CRLF
Thanks again Maarten for your time, Resharper indeed told me to skip the Where clause :) In this scenario context.TblEmailPostbox is an ObjectSet<tblEMailPostBox>. I am currently implementing the precompiled version of the query: Func<emaildataentities, long,="" emaildatacontext.model.tblemailpostbox=""> getSingleEmailByIdQuery = CompiledQuery.Compile<emaildataentities, long,="" emaildatacontext.model.tblemailpostbox="">((context, emailId) => context.tblEMailPostBox.FirstOrDefault(f => f.id == emailId)); and I invoke it like this: tblEMailPostBox oDataEmail = getSingleEmailByIdQuery.Invoke(context, id); just for improving the performance as I have read about. I have run into the OutOfMemoryException about five times and it's a really big record (Email with attachments - structure is pretty old and was accessed mainly using a SqlDataReader). Just to make sure I understood correctly. You mentioned I should "query the right records from the database, instead of querying everything and resolving it in your application (as you are doing now)". This is confusing me a little because I assumed I would do it like that. The context variable is the ObjectContext I use for accessing the table. Would you mind to give me a little hint on how to query the right records only in this example? I really appreciate your help Maarten, cheers Andy