tags:

views:

127

answers:

1
+1  Q: 

Alternative to Windows Azure tables out of the cloud

Hi :)

I'm developing a .NET app, which needs to run both on Azure and on regular Windows Servers(2003). It needs to store a few GB of data and SQL Azure is too expensive for me, so I'll use Azure tables in the cloud version. Can you recommend a storage solution, which will run on standalone servers and have an API and behavior similar to Azure tables? From what I've seen Server AppFabric does not include Tables.

TIA

+2  A: 

I'm not sure which storage solution to recommend, but just about any database solution would work provided that you write an Interface to abstract all your data storage code. Then write implementations of that interface for Azure Table storage and whatever other database you want to use on the non-cloud server

You should be doing that anyway so that your code isn't tightly coupled with Azure Table Storage APIs.

If you combine coding against that Interface with an IoC container, then a single line of code or a single configuration setting would enable you to switch between data implementations based on which platform the code is running on.

Dennis Palmer  2010-05-03 17:28:46

related questions

Table Column Formatting
How do you truncate all tables in a database using TSQL?
how to see the schema of a db2 table (file)
Tools for refactoring table-based HTML layouts to CSS?
Page working in FF, not in IE, where to start
Hiding table rows without resizing overall width...
DIV with overflow:auto and a 100% wide table problem
For tabular data, what renders faster, CSS or <TABLE>?
I need my html table's body to scroll and its head to stay put
How to line up items of varied length in a resizable space in CSS?
CSS to make a table column take up as much room as possible, and other cols as little
Best approach for sortable table with a lot of data
A more advanced table/spreadsheet SWT implementation
JSF how do I retrieve the selected rows of a woodstock table
How to scroll only the right side of a table, listview, or datagrid?
Make a div fill the remaining screen space
How to stretch an HTML table to 100% of the browser window height?
SqlServer create table with MySql like auto_increment primary key
Why not use tables for layout in HTML?
Should Tables be avoided in HTML at any cost?
HTML drag and drop sortable tables
CSS overflow table row positioning
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Configurable Table Prefixes with a .Net OR/M?
SQL Table Aliases - Good or Bad?