Last night in Bracknell I gave part of a presentation on Microsoft 2008 technologies: the agonies and ecstasies of Linq. This was to the increasingly misnamed VBUG. There were more C developers than VB. The food was good and we had a good audience.
An edited version of the text of the slides, with additional comments and Linq links follows:
AvaPA – VBUG Bracknell 2008 Launch
2005 - 2008
Keep a copy of your *.proj/*.sln – everything else is compatible
Not sure why you would want to though…
White space handling much better.
Layout seems to be maintained.
Ajax issues 1
Why my Ajax stopped working when I went from 2.0 to 3.5
How to fix it:
Download the latest version of Ajax for 3.5
Copy the old code to a safe place
Delete then reinsert the Ajax extension
Copy in the missing bits!
SQL to Linq 1
- Stored procedure comments:
Not before
Not after
In the middle…
If somone or something puts your puts your XP computer in hibernate:
right clicking on a stored proc will not give you the open option!!!
Close and restart the project to cure.
- Linq 1 How to bind a list (as opposed to a grid)
Use Datafield properties
No “Selected” binding for a check list???
- Linq 2
How to run an update stored proc:
Import it into your data model
Declare it and just do it!
- Linq 3
Pitfall of using .single()
Solutions may vary
- Linq 4
How (not) to design a sp so it works with Linq
Declare @Tbl TABLE (x, y, z)
Final select: SELECT x,y,z FROM @Tbl T
Linq 4
How (not) to design a sp so it works with Linq
IF @Var = 1
SELECT * FROM MyTable
IF @Var = 2
SELECT * FROM MyTable2
- Linq 5
Declarative order not maintained.
Dhhhoooo…
May be news for MS on this later….
Select z, x, y From Mytable
From Mytable Select z, x, y !!!!
Asp net wiz v2.0
An unexpected (for me) feature of the user wizard:
If you still logged in as an existing user,the User wizard may think you are trying to change your existing password rather than create a new user!
Altering a proc 1
Updating an existing stored procedure:
Run the new script against that database
Refresh the proc list Not < F 5 > !!!
Delete the old version
Drag in the new version
Save
Useful linq Links
Web casts
http://www.asp.net/learn/webcasts/default.aspx?tabid=63
Videos
http://www.asp.net/learn/videos/default.aspx?tabid=63
http://www.windowsclient.net/learn/videos.aspx
http://www.asp.net/learn/linq-videos/
Blogs
http://blogs.msdn.com/bethmassi/
http://weblogs.asp.net/scottgu/
http://blogs.msdn.com/vbteam/
http://weblogs.asp.net/scottgu/archive/2007/05/19/using-linq-to-sql-part-1.aspx
http://weblogs.asp.net/scottgu/archive/2008/05/12/visual-studio-2008-and-net-framework-3-5-service-pack-1-beta.aspx
Thank you
If you found this useful please place a public link on any web site or Social networking site to our site or this article.
Ian