I ran into the following error when trying to create the Test Storage Tables from Within Visual Studio 2008.
Unhandled Exception: System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.Module._GetTypesInternal(StackCrawlMark& stackMark)
at System.Reflection.Assembly.GetTypes()
at Microsoft.ServiceHosting.DevelopmentStorage.Table.DatabaseGenerator.GenerateDataBase(String server, String dbName, String[] assemblyPaths, Boolean forceCreate, ValidationHandler validationHandler)
at Microsoft.ServiceHosting.DevelopmentStorage.Table.Program.Main(String[] args)
Took me forever to figure out what the problem was, but essentially the Azure tools try to generate entities from every dll referenced in your project, and it expects the dlls to be in either the GAC or the Bin folder of the WebRole. Now if you've integrated other projects into your Azure project, this might not be the case. The solution then is to run DevGenTables Manually using parameters similar to below.
"c:\Program Files\Windows Azure SDK\v1.0\bin\DevtableGen.exe" /forceCreate "/database:YourDatabaseNameHere" "C:\pathtoproject\Azure_WebRole\bin\Azure_WebRole.dll;C:\pathtoproject\Azure_WebRole\bin\StorageClient.dll;C:\pathtoproject\Azure\AzureWorker\bin\Debug\AzureWorker.dll"
You'll need to change the command to specify the dlls you are using in your project, but once that is done, you should see a message like this:
Windows(R) Azure(TM) Development Table database generation tool version 1.0.0.0 for Microsoft(R) .NET Framework 3.5
Copyright (c) Microsoft Corporation. All rights reserved.
DevTableGen : Generating database 'Azure'
DevTableGen : Generating table 'TableStorage' for type Azure_WebRole.TableStorageEntity'