I'll give a +1 for SQLite. Had a small, single-user project for a non-profit that we wanted to use ActiveRecord with. SQLite worked just fine with AR and it exposed just a single file that made backups easier for the user. I don't recall having any problems and the project came together quickly. No install was a bonus too.
--- Patrick Steele http://weblogs.asp.net/psteele On Mon, Jul 18, 2011 at 12:13 PM, Juanma <[email protected]> wrote: > Regarding firebird... > > Is it really a good option for an embedded deployment? > Is the NH support good enough? > > As I said in my previous mail we found a lot of issues with sql express > installation process, and we are currently looking for an embedded > alternative. I don't like access, and I was considering SQLite or SqlCE. > > > On Mon, Jul 18, 2011 at 5:13 PM, Ken Egozi <[email protected]> wrote: >> >> Access also needs some form of installation on a machine. not all windows >> machines can run the Jet 4.0 engine (which is what access use). >> You should be looking into SQLite in file mode. It has a good support for >> NHibernate. It is not however very suitable for high concurrency but I >> suspect it is not a problem in your scenario. >> Not that Access is wrong or anything, but it has some quirks, and its SQL >> implementation is not per the standard so you might hit a few hard-to-solve >> gotchas >> >> another option is Firebird which also has an embedded mode, and fairly >> good .NET drivers. >> >> >> Ken Egozi. >> http://kenegozi.com/blog >> http://social.sears.com >> http://www.musicglue.com >> http://www.castleproject.org >> http://www.idcc.co.il - הכנס הקהילתי הראשון למפתחי דוטנט - בואו בהמוניכם >> >> >> On Mon, Jul 18, 2011 at 6:04 PM, Juanma <[email protected]> wrote: >>> >>> The problem with Sql Server is the installation process. We have found a >>> lot of issues when trying to install SQL on different environments, with >>> many combinations of platforms (WinXP, Vista, 7), architectures (x86, x64), >>> installed componentes, etc. >>> >>> On Mon, Jul 18, 2011 at 12:09 PM, umefarooq <[email protected]> wrote: >>>> >>>> really great thanks for reply, i know that Sql server is the best >>>> combination with .net, i will give a try >>>> >>>> -- >>>> 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. >> >> -- >> 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. > -- 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.
