GDataDB

Just released GDataDB 0.2. GDataDB is a database-like interface to Google Spreadsheets for .Net. This is a maintenance release. Here's the short changelog: Andrew Yau implemented deleting tables and databases (which means deleting worksheets and ... [More] spreadsheets respectively). Ryan Farley fixed a bug with read-only and write-only properties in the mapped class. Updated to use the latest GData library. Binaries are in github. Also, Ryan recently wrote a nice article about GDataDB, check it out. UPDATE 11/3/2010: Ryan Farley added GDataDB and GDataDB.Linq to the NuGet package repository. Thanks Ryan! [Less]

Just released GDataDB 0.2. GDataDB is a database-like interface to Google Spreadsheets for .Net. This is a maintenance release. Here's the short changelog: Andrew Yau implemented deleting tables and databases (which means deleting worksheets ... [More] and spreadsheets respectively). Ryan Farley fixed a bug with read-only and write-only properties in the mapped class. Updated to use the latest GData library. Binaries are in github. Also, Ryan recently wrote a nice article about GDataDB, check it out. UPDATE 11/3/2010: Ryan Farley added GDataDB and GDataDB.Linq to the NuGet package repository. Thanks Ryan! [Less]

Just released GDataDB 0.2. GDataDB is a database-like interface to Google Spreadsheets for .Net. This is a maintenance release. Here's the short changelog: Andrew Yau implemented deleting tables and databases (which means deleting worksheets and ... [More] spreadsheets respectively). Ryan Farley fixed a bug with read-only and write-only properties in the mapped class. Updated to use the latest GData library. Binaries are in github. Also, Ryan recently wrote a nice article about GDataDB, check it out. UPDATE 11/3/2010: Ryan Farley added GDataDB and GDataDB.Linq to the NuGet package repository. Thanks Ryan! [Less]

For a little project I'm coding, I needed to programatically post new rows to a Google spreadsheet. Luckily, there are .NET bindings to the Google Data APIs. But they're still too low-level if you want to use the spreadsheet as a database. I looked ... [More] around the source repo for awhile and found this little gem in python. In the words of its creator, it helps: Make the Google Documents API feel more like using a database. This module contains a client and other classes which make working with the Google Documents List Data API and the Google Spreadsheets Data API look a bit more like working with a heirarchical database. Using the DatabaseClient, you can create or find spreadsheets and use them like a database, with worksheets representing tables and rows representing records. Just what I needed! So I ported it to .net, and here is the result. The biggest difference with the python version is that tables in .net are strongly typed. When you define a Table, the Entity's public properties are serialized when posting to the spreadsheet. The sample app is pretty much self-explanatory. You can do CRUD operations on the rows stored on a worksheet. The structured query operators are limited, but I didn't need more. I even threw in a LINQ provider (base classes courtesy of Matt Warren), so you can do strongly typed queries: class Entity {   public int Amount { get; set; } } ... Table<Entity> t = ... var rows = from e in t.AsQueryable()            where e.Amount == 5            select e;It's still a bit rough around the edges, but usable.UPDATE 11/03/2010: released GDataDB 0.2 [Less]

For a little project I'm coding, I needed to programatically post new rows to a Google spreadsheet. Luckily, there are .NET bindings to the Google Data APIs. But they're still too low-level if you want to use the spreadsheet as a database. I looked ... [More] around the source repo for awhile and found this little gem in python. In the words of its creator, it helps: Make the Google Documents API feel more like using a database. This module contains a client and other classes which make working with the Google Documents List Data API and the Google Spreadsheets Data API look a bit more like working with a heirarchical database. Using the DatabaseClient, you can create or find spreadsheets and use them like a database, with worksheets representing tables and rows representing records. Just what I needed! So I ported it to .net, and here is the result. The biggest difference with the python version is that tables in .net are strongly typed. When you define a Table, the Entity's public properties are serialized when posting to the spreadsheet. The sample app is pretty much self-explanatory. You can do CRUD operations on the rows stored on a worksheet. The structured query operators are limited, but I didn't need more. I even threw in a LINQ provider (base classes courtesy of Matt Warren), so you can do strongly typed queries: class Entity {   public int Amount { get; set; } } ... Table<Entity> t = ... var rows = from e in t.AsQueryable()            where e.Amount == 5            select e;It's still a bit rough around the edges, but usable.UPDATE 11/03/2010: released GDataDB 0.2 [Less]

For a little project I'm coding, I needed to programatically post new rows to a Google spreadsheet. Luckily, there are .NET bindings to the Google Data APIs. But they're still too low-level if you want to use the spreadsheet as a database. I looked ... [More] around the source repo for awhile and found this little gem in python. In the words of its creator, it helps:Make the Google Documents API feel more like using a database. This module contains a client and other classes which make working with the Google Documents List Data API and the Google Spreadsheets Data API look a bit more like working with a heirarchical database. Using the DatabaseClient, you can create or find spreadsheets and use them like a database, with worksheets representing tables and rows representing records.Just what I needed! So I ported it to .net, and here is the result. The biggest difference with the python version is that tables in .net are strongly typed. When you define a Table<Entity>, the Entity's public properties are serialized when posting to the spreadsheet. The sample app is pretty much self-explanatory. You can do CRUD operations on the rows stored on a worksheet. The structured query operators are limited, but I didn't need more. I even threw in a LINQ provider (base classes courtesy of Matt Warren), so you can do strongly typed queries: class Entity {   public int Amount { get; set; } } ... Table<Entity> t = ... var rows = from e in t.AsQueryable()            where e.Amount == 5            select e;It's still a bit rough around the edges, but usable.UPDATE 11/03/2010: released GDataDB 0.2 [Less]

For a little project I'm coding, I needed to programatically post new rows to a Google spreadsheet. Luckily, there are .NET bindings to the Google Data APIs. But they're still too low-level if you want to use the spreadsheet as a database. I looked ... [More] around the source repo for awhile and found this little gem in python. In the words of its creator, it helps: Make the Google Documents API feel more like using a database. This module contains a client and other classes which make working with the Google Documents List Data API and the Google Spreadsheets Data API look abit more like working with a heirarchical database. Using the DatabaseClient,you can create or find spreadsheets and use them like a database, with worksheets representing tables and rows representing records. Just what I needed! So I ported it to .net, and here is the result. The biggest difference with the python version is that tables in .net are strongly typed. When you define a Table<Entity>, the Entity's public properties are serialized when posting to the spreadsheet. The sample app is pretty much self-explanatory. You can do CRUD operations on the rows stored on a worksheet. The structured query operators are limited, but I didn't need more. I even threw in a LINQ provider (base classes courtesy of Matt Warren), so you can do strongly typed queries: class Entity {  public int Amount { get; set; }}...Table<Entity> t = ...var rows = from e in t.AsQueryable()           where e.Amount == 5           select e; It's still a bit rough around the edges, but usable. UPDATE 11/03/2010: released GDataDB 0.2 [Less]