Distributed databases

[piotr.zielinski]

Hey,
In my project I’m going to use distributed databases. My target is creation of sales system so I will distribute for example order table. Mainly I use horizontal partition.
So my question is about solutions for .NET?Do you know any framework that supports heterogenic distributed databases?I want to define partition strategy in separate class(or alternatively in separate class). Then framework should allow me insert record and decide which database should be used.
It’s my first distributed database project so please share your experience. I have no idea how to start.

[Kirk81]

hi,

I'm interesting in a similiar topic. Any hints?

[olivthill2]

I have used ADOdb and it is working very well. With the same syntax, I could access and update data from Oracle, Sybase and MS Access. Only a connection string is different for these databases. See http://en.wikipedia.org/wiki/ADOdb
But it works with PHP or Python, not with .Net.