you're right, we can't name it 'unit' for what I said 2011/8/1 Berke Sokhan <[email protected]>
> 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. > -- 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.
