I don't think you will find any tutorials covering the use of Active Record with an Access database.
That said, Castle ActiveRecord is built on top of the NHibernate ORM - so what you are looking for is the Jet dialect/driver for NHibernate - this is not a standard part of NHibernate, but is part of the nhcontrib project here: http://nhcontrib.svn.sourceforge.net/viewvc/nhcontrib/trunk/src/NHibernate.JetDriver/ Having used this code in the past, what is generally easiest is adding the source code for the Jet Driver directly to your application code, so it's compiled against the same version of NHibernate as ActiveRecord is using, and so you can add hacks to get things working for your particular project - If the reason for using access is so you can have the database files deployed as part of your application (as opposed to connecting to a database on the database server), I would instead suggest looking at user-attached sql instances, they might do what you need: http://msdn.microsoft.com/en-us/library/ms254504.aspx Also Sql Server Express is free - so if the concern is the cost associated with Sql Server, that's often a non-issue for your own pet projects (or you can always use MySql or PostgreSql - both which have good support in NHibernate). If you're learning Castle Active Record, I would suggest just using Sql Server for your first project, as you will find it a lot easier. My 2ΓΈ worth. Cheers, Alex On Mon, Jul 18, 2011 at 6:54 PM, umefarooq <[email protected]> wrote: > Hi i am a PHP developer and work on Codeigniter framework and really > like their active records, now i am trying to develop a small database > form application in .net and found really handy Castle AR and i really > like how its working, but i am facing some problem. i want to use MS > Access as Database engine. i googled and found some Castle video cast > but most of them are using MS Sql, i need simple tutorial for Castle > AR and MS Access and really basic so i will build on that. > > -- > You received this message because you are subscribed to the Google Groups > "Castle Project Users" group. > To post to this group, send email to [email protected] > . > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/castle-project-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
