LINQ
Category microsoft
LINQ is Language Integrated Querying
Language for handling data within the source code stream. Not just SQL, but XML, objects, datasets, plus anything else that a driver can be written for.
This is almost (almost) like introducing some declarative or even functional programming ideas into the Microsoft languages. May take a while to get the head round the implications of all this!
The whole thing is built on 2 Interfaces: IEnumerable and IQueryable, so very extensible. Nice.
Demo now, of using this in both VB and C#. Very powerful.
Good presenter in this session. A welcome change from the undead we've had so far!
VB9 also supports inline XML. Very very useful, and works like a dream with the LINQ stuff. Dynamic parts of the XML use an ASP-like syntax. So easy....
New project item type of LINQ-to-SQL to help generate low-level data access code using the LINQ technology.
Using this approach to access SQL is effectively, however, doing a lot of dynamic SQL. This could well have performance implications, even if the tools do provide nice ways of defining and maintaining tbat dynamic SQL. Hmm. Ah, he's addressing that concern now. So, this can be used to front stored procs, not just raw tables. The advantage is that LINQ will manage the marshalling of data into simple addressable data access objects. Also works very well with table-valued functions.
All in all VERY interesting...
Time for lunch.
LINQ is Language Integrated Querying
Language for handling data within the source code stream. Not just SQL, but XML, objects, datasets, plus anything else that a driver can be written for.
This is almost (almost) like introducing some declarative or even functional programming ideas into the Microsoft languages. May take a while to get the head round the implications of all this!
The whole thing is built on 2 Interfaces: IEnumerable and IQueryable, so very extensible. Nice.
Demo now, of using this in both VB and C#. Very powerful.
Good presenter in this session. A welcome change from the undead we've had so far!
VB9 also supports inline XML. Very very useful, and works like a dream with the LINQ stuff. Dynamic parts of the XML use an ASP-like syntax. So easy....
New project item type of LINQ-to-SQL to help generate low-level data access code using the LINQ technology.
Using this approach to access SQL is effectively, however, doing a lot of dynamic SQL. This could well have performance implications, even if the tools do provide nice ways of defining and maintaining tbat dynamic SQL. Hmm. Ah, he's addressing that concern now. So, this can be used to front stored procs, not just raw tables. The advantage is that LINQ will manage the marshalling of data into simple addressable data access objects. Also works very well with table-valued functions.
All in all VERY interesting...
Time for lunch.
