Arun Stephens

Windows Azure Development Storage with real SQL Server

I don’t have SQL Server Express, I’ve got the real deal. Development Storage for Windows Azure assumes you are using SQL Server Express with the instance name SQLEXPRESS. Thanks to this article I now know that you just need to edit the config file for DevelopmentStorage.exe, which is usually located in C:Program FilesWindows Azure SDKv1.0binDevelopmentStorage.exe.config. There are two spots to modify. The first is the connection string (XPath: /configuration/connectionStrings/add/@connectionString) and the second is the dbServer attribute of the Table service (XPath: /configuration/developmentStorgeConfig/service/service[@name=‘Table’]/@dbServer). Read more →

Entity Framework: Part 2

I have been reading a bit of the documentation about the ADO.NET Entity Framework. There are a few passages that relate to my previous post: Because referenced objects are not automatically loaded, you must call the Load method on the entity reference to load the related object data into the object context. You can also specify a query path that defines which related objects to load with returned objects. For more information, see Querying Data as Objects (Entity Framework). Read more →

LINQ to Entities – my first steps

I have had little bit of experience with LINQ to SQL, but recently read that Microsoft is instead concentrating on LINQ to Entities. I have just started a new project, so thought decided to use LINQ to Entities instead. And I ran into a problem. I haven’t managed to find a solution to it yet, so I figured that I would write about it here and hopefully, once I have figured out what I was doing wrong, it might be able to help someone else out. Read more →

I like LINQ

LINQ stands for Language Integrated Query, a new feature of the .NET Framework 3.5. And it’s cool. I have used LINQ to SQL on the My Flatmates Facebook application, and it made things a lot quicker. LINQ to SQL creates classes out of your database tables. Then you can use LINQ statements to create instances of the classes from your data. I think that Ruby is similar in that you work directly against the database. Read more →