Geeks With Blogs

Rohan Cragg July 2013 Entries
Configuring SQL Server Express Edition for remote access
I wanted to access SQL Express on my local machine from within a Client Hyper=V virtual machine on the same Domain. This article got me most of the way there: http://akawn.com/blog/2012/... But it was a bit out of date. My steps were: Enable TCP/IP Protocol in SNAC Restart SQL Server Configure (Windows 8) Firewall to allow all Inbound for sqlservr.exe Footnote: I thought this might be relevant (nice to be able to script it): http://support.microsoft.co... ......

Posted On Wednesday, July 24, 2013 1:39 PM

Joining to an arbitrary SQL set in EF5
I wanted to be able to write a hierarchical query in LINQ but found that it’s not something you can do. I knew how to write TVFs or User Defined Table Valued Functions and had used them in joins in pure TSQL before but I suspected that it ought to be possible to re-use that SQL within an EF model so I went hunting… Eventually I was inspired by this http://code.msdn.microsoft.... First, I added Function Imports for my TVFs to my (classic Database-First ......

Posted On Tuesday, July 9, 2013 5:39 PM

Copyright © rohancragg | Powered by: GeeksWithBlogs.net