embedded Databases in mono?

spector00 · #1 2nd November 2008, 04:23 PM

Is there any embedded databases that can run in .net and basicaly just do a copy paste of that application and being able to run in mono 2.0 with no problems?

JohnVV · #2 2nd November 2008, 05:17 PM

This is MS's .net framework here we are talking about so probably not

mndar · #3 2nd November 2008, 05:43 PM

Quote:

Is there any embedded databases that can run in .net and basicaly just do a copy paste of that application and being able to run in mono 2.0 with no problems?

I think that'll depend on whether you are using a data provider to connect to the database or whether you are using a odbc connection kinda thing. The application itself might run without any changes

Reisswolf · #4 2nd November 2008, 06:08 PM

This is a problem in whose solution I have a great deal of interest.

I believe that once Mono starts supporting the (excellent) LINQ extensions, the solution to your problem will become much easier. I can imagine Mono's LINQ extensions directly mapping MySQL or PostgreSQL tables much like how the .NET LINQ extensions now work with tables in Microsoft SQL Server. When that starts to happen, porting projects and data models will become a breeze.

I never thought I would say this, but I have become a big fan of .NET and the functional programming capabilities of LINQ in C#. Not quite Haskell--but don't bet against Microsoft bringing LINQ much closer to Haskell by the time .NET 4.0 or .NET 5.0 is released.

spector00 · #5 3rd November 2008, 04:50 AM

i was considering in doing something odd, to use the monos data provider in .net and see if it ran. or at least if it will let me at least compile. then i could use a branch in the code. if the platform is windows use .net libs if linux or mac use monos.

all though its still a theory i would like some opinion on this or other theorys to see if it works.

spector00 · #6 11th November 2008, 10:45 PM

Turns out that sqlite is a nice DB that can be run using mono's dll on .net and run in Linux with no change at all.

Sqlite aint the best and it isnt fully functional YET. But for storing data and reading from its DB it works. Foreign keys dont work but you can emulate them if necesary by triggers or by code.

Over it seems like a good way to move.