[Mono-dev] subsonic test drive

[Joe Audette]

Hi,

I've been working with SubSonic myself recently and have been able to
use it on Mono with MySql and PostgreSQL using some custom providers.

I'm using a custom build of SubSonic for several reasons. My custom
build leaves out their Provider for the MS Enterpise Blocks and also
leaves out their SQLite provider because it could not work with Mono.
I implemented a provider for SQLite that uses Mono.Data.Sqlite so in
theory it should work on Mono though I have not tested it (except on
Windows). I also found someone who started SubSonic provider
implementations for PostgreSQL and Firebird Sql and was able to take
their initial work and get it working to meet my needs (I haven't
tested the Firebird one on Mono but it should work).

SubSonic has code generation functionality that I have not tried on
Mono. I've only so far done code generation against MS SQL on windows,
but I am able to use the resulting generated code and the core
SubSonic dll on mono against both MySql and PostgreSql databases with
schema that corresponds to the MS SQL schema. I've also tested the
generated code against SQLite and Firebird but my testing has been on
Windows (though again no reason I can think of it won't work on Mono).

If you're interested you can get my custom version of SubSonic source
code from here:
https://forgesvn1.novell.com/svn/mojoportal/vendor/SubSonic

I like SubSonic very much because it has the benefits of typical OR
mapper but unlike many of them allows you to use it as data access
only and fully abstract it away from the real business objects so that
they have no dependency on SubSonic. Most OR mappers want to be in
charge of constituting your business objects whereas SubSonic can be
used to just pass data to and from your business obejcts.

Hope it helps,

Joe




2008/2/25 Sharique uddin Ahmed Farooqui <safknw at gmail.com>:
> Hi,
>
> I'm trying Subsonic http://www.subsonicproject.com/.
> When i compile my test web application. I get this error
> The nested type `ComponentModel' does not exist in the type
> `Northwind.System'(CS0426)]
>
> I'm using mono 1.2.6 and monodevelop 0.19.
>
> I didn't find System.ComponentModel.dll  in "Reference Edit" dialog box.
>
> Is this not implemented?
> --
> Sharique uddin Ahmed Farooqui
> (C++/C# Developer, IT Consultant)
>  A revolution is about to begin.
> A world is about to change.
> And you and I are "the initiator".
> _______________________________________________
>  Mono-devel-list mailing list
>  Mono-devel-list at lists.ximian.com
>  http://lists.ximian.com/mailman/listinfo/mono-devel-list
>
>



-- 
Joe Audette
Software Solutions Architect
Source Tree Solutions, LLC
PO Box 621861
Charlotte, NC 28262
704.323.8225
joe.audette at gmail.com
http://www.sourcetreesolutions.com
http://www.mojoportal.com