Geeks With Blogs
Sean Barlow November 2011 Entries
You cannot do cross joins in SQL Azure but there is a way around that....
So I was asked today how to do cross joins in SQL Azure using Linq. Well the simple answer is you cant do it. It is not supported but there are ways around that. The solution is actually very simple and easy to implement. So here is what I did and how I did it. I created two SQL Azure Databases. The first Database is called AccountDb and has a single table named Account, which has an ID, CompanyId and Name in it. The second database I called CompanyDb and it contains two tables. The first table I ......

Posted On Friday, November 18, 2011 10:32 PM

Mounting a Microsoft Azure CloudDrive in a VMRole
Mounting a Drive in a VMRole is a little more complicated then a web or worker. The Web and Worker roles offer OnStart and OnStop events, which you can use to mount or unmount your drives. The VMRole does not have these same events so you have to provide another way for the drives to be mounted or unmounted. The problem I have run into is what if you have multiple drives and you only want to mount certain drives. How do you let your user mount the drive. I am not going to go into details on what ......

Posted On Sunday, November 13, 2011 12:23 PM

Copyright © SeanBarlow | Powered by: GeeksWithBlogs.net