There are no differences for SQLite, you can take any AR/NH tutorials, just configure it for SQLite ( Sample: https://github.com/ricardoborges/NHibernate-Samples/blob/master/src/01/NH.Sample.S01.GetStarted/App.config )
I generally use SQLite for unit testing, when the architecture doesn't have repositories. But, I've made a small winforms software using SQLite for production. The boring thing about SQLite is the x86 and x64 versions. I've got a lot of problems with x64 version and .NET 4... the same build was working fine on intel64 and crashing on amd64... are there any differences? 2011/7/31 umefarooq <[email protected]> > yes sqlite is also a good option for small and single user project, no > installation and easy to deploy, anybody has proper tutorial for > sqlite and castle project > > On Jul 19, 11:12 am, Juanma <[email protected]> wrote: > > I hadn't thought of that, and is a very good point. Currently we have a > very > > simple migration system that allows us to alter the schema in the most > > common ways, and it would be easy to port to SQLCE (because the DDL > syntax > > is nearly identical to SQL). > > > > On Mon, Jul 18, 2011 at 10:09 PM, Alex Henderson <[email protected] > >wrote: > > > > > > > > > > > > > > > > > NHibernate makes it easy to smooth out the different data type issues > > > between databases. For me the only irksome thing is that once you > project > > > becomes brownfield the approach to database migrations for Sql Server > and > > > Sqlite are quite different - with sql server you can add/remove/change > > > columns on tables etc. - but Sqlite has a reduced set of available DDL > > > options, so generally you need to create a new table in the right > shape, > > > copy all the data across, delete the old table, rename the new table. > > > > > Most of the current migration frameworks for .Net don't handle this > very > > > well because they don't have the concept of a table "model" carried > between > > > each migration step. > > > > > On Tue, Jul 19, 2011 at 5:07 AM, Juanma <[email protected]> wrote: > > > > >> Hmmm, actually I suppose the real problem would be more different > > >> datatypes than the schema itself. > > > > >> On Mon, Jul 18, 2011 at 7:01 PM, Patrick Steele < > [email protected] > > >> > wrote: > > > > >>> I have not done a comparison of the schema options. For the project > I > > >>> used, migration was not an option. > > > > >>> However, if you're using ActiveRecord on a new database, there's the > > >>> GenerateSchema method to create your schema. You should be able to > > >>> use that with both SQLite and SQL Server. > > > > >>> --- > > >>> Patrick Steele > > >>>http://weblogs.asp.net/psteele > > > > >>> On Mon, Jul 18, 2011 at 12:51 PM, Juanma <[email protected]> wrote: > > >>> > Is the SQLite schema very different from the SQL Server one? > > > > >>> > In our project, we'd like to keep two versions of the app, a "lite" > > >>> version > > >>> > with reduced functionality but easier deployment, and a "full" > version, > > >>> more > > >>> > powerful and with concurrent users support. Since we are going to > use > > >>> SQL > > >>> > Server in the full version and we need to provide a migration path > from > > >>> > "lite" to "full" version, I'd like to find an embedded database > with a > > >>> > schema similar to SQL Server. > > > > >>> > I've worked in the past with SQLCE (mainly in WinMo devices), but > all > > >>> > articles I've found on the net state that SQLite is the right > option > > >>> over > > >>> > SQLCE. > > > > >>> > On Mon, Jul 18, 2011 at 6:29 PM, Patrick Steele < > > >>> [email protected]> > > >>> > wrote: > > > > >>> >> 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. > > > > >>> > -- > > >>> > 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. > > -- Ricardo -- 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.
