Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Fri Jul 17 15:34:45 CDT 2009
Hi Gustav, Yes, this is a great feature. I have just published SPJ sample database at: http://northwind.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=26600#D ownloadId=75624 I have made this sample database developed here by typing its data from the book, which I have got purchased here in 1981, in USSR, Russian Edition. С.J.Date has released this year yet another book - I'd recommend it as it's IMO more modern/advanced/suitable for professional db developers: SQL and Relational Theory, 1st Edition by C.J. Date January 2009 ISBN-10: 0-596-52306-8 http://oreilly.com/catalog/9780596523060/ "Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL, with numerous examples and clear explanations of the reasoning behind them. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book." -- Shamil -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Friday, July 17, 2009 7:17 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] LINQ for EF Example (Part I) Hi Shamil No, I wasn't aware of exactly this - or rather down to what level the SQL code generator operates - but it is a great feature. Where can the C.J. Date test database you mention be obtained? I found the book for download as a PDF here: http://www.scribd.com/doc/13078295/An-Introduction-to-Database-Systems-8Ed-C -J-Date-Solutions-Manual It seems to be complete. Not sure what the deal is? /gustav >>> shamil at smsconsulting.spb.ru 17-07-2009 09:22 >>> Hi All, Have a look what LINQ for EF can do - I mainly mean that it can combine C# subqueries into one SQL expression executed on server side. I personally was unaware of this feature. Yes, I have read about LINQ's "lazy execution mode" but I haven't seen such advanced examples. Of course I could have missed them. Anyway I wanted to post about this LINQ feature here - just for the records J This posting is split into three parts to get through dba-VB posting size limitations. Example uses well known C.J. Date sample database from his "An Introduction to Database Systems" book (http://www.amazon.com/Introduction-Database-Systems-C-Date/dp/0201385902): _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4255 (20090717) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru __________ Information from ESET NOD32 Antivirus, version of virus signature database 4255 (20090717) __________ The message was checked by ESET NOD32 Antivirus. http://www.esetnod32.ru