sidenote: It is interesting that you call tests that involves actual databases, unit tests. I think you mean integration tests.
2011/7/31 Ricardo Borges <[email protected]> > 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. > -- Berke SOKHAN. http://twitter.com/berkesokhan http://blog.berkesokhan.com http://www.birliktegelistir.com/editors.aspx -- 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.
