GDataDB is a database-like interface to Google Spreadsheets for .Net.
It models spreadsheets as databases, worksheets as database tables, and rows as records.
A few articles documenting it:
- http://bugsquash.blogspot.co.uk/search/label/gdatadb
- http://ryanfarley.com/blog/archive/2010/09/24/using-google-docs-as-an-online-database.aspx
Google has changed the authentication scheme since those articles were written. Now it requires OAuth2.
To set this up visit http://console.developers.google.com , create a new project, enable the Drive API, create a new client ID of type "service account" and download the P12 key. Use the service account email address and the P12 key as shown in this example .
If you want to access any documents from your personal gmail account, share them (edit permissions) with the service account email address and make sure that they're in the root folder of Drive.
Original idea for GDataDB borrowed from https://github.com/google/gdata-python-client/blob/master/src/gdata/spreadsheet/text_db.py
