Thanks! Removing the explicit call to CustomSqlTypeIs and adding the
explicit dialects for each back end seemed to make the difference.
Thank you very much for your help. Not to be greedy, but would you
happen to know if it's possible to change the default mapping of byte
[] properties for MsSql from varbinary(8000) to varbinary(Max)? If
not, that's cool. You've helped plenty. Thanks again.
On Apr 27, 11:15 pm, Hudson Akridge <hudson.akri...@gmail.com> wrote:
> > are you saying that I should remove the explicit call to "CustomSqlTypeIs"
> > and let NHibernate automatically take care of the conditional logic for what
> > the Sql type should be?
>
> Yup :) This is the exact reason that dialects exist. Dialects are a way to
> work with a database consistently, completely agnostic of the specific
> implementation nuances. In your case, the differences between MsSql and
> SqLite's binary container columns.
>
>
>
> On Mon, Apr 27, 2009 at 11:04 PM, Action Jackson <crjac...@gmail.com> wrote:
>
> > Hi Hudson, thank you for the quick response. FileData is a byte
> > array (byte[]). As for my database configuration, I am using the
> > SqlLite20Driver and the SQLiteDialect for testing purposes. For your
> > #1 suggestion, are you saying that I should remove the explicit call
> > to "CustomSqlTypeIs" and let NHibernate automatically take care of the
> > conditional logic for what the Sql type should be? Also, I noticed I
> > messed up the copy and paste job of my mapping. The constructor name
> > didn't match the class name. Sorry for any confusion out there.
>
> > public class MyFileMap : ClassMap<MyFile>
> > {
> > public MyFileMap()
> > {
> > Id(x => x.Id);
> > Map(x => x.FileData)
> > .CustomSqlTypeIs("varbinary(MAX)");
> > }
> > }
>
> > On Apr 27, 10:34 pm, Hudson Akridge <hudson.akri...@gmail.com> wrote:
> > > 1.) What is your FileData? Assuming it's marked as serializable,
> > NHibernate
> > > should default to mapping it to a BLOB or varbinary depending on the
> > dialect
> > > used during configuration. You then set the different dialects during
> > > different initialization routines depending on if you're testing or
> > running
> > > production code. That's actually the entire intent behind the Dialect
> > > concept in a NHibernate configuration.2.) Assuming there's some scenario
> > > that it doesn't make any sense to use #1 in, you could always do it the
> > long
> > > way, and just have a static string in a class that's initialized to a
> > > different value (BLOB vs varbinary) depending on your configuration. Then
> > > your CustomSqlTypeIs() would call that string holder. Or something along
> > > those lines. I'd have to say, in my experience, #1 is the way to go if
> > you
> > > can help it :)
>
> > > On Mon, Apr 27, 2009 at 9:49 PM, Action Jackson <crjac...@gmail.com>
> > wrote:
>
> > > > Does anyone know if it is possible to use conditional logic to
> > > > construct Fluent mappings? Specifically, I would like to take the
> > > > following mapping:
>
> > > > public class MyFileMap : ClassMap<MyFile>
> > > > {
> > > > public WksFileMap()
> > > > {
> > > > Id(x => x.Id);
> > > > Map(x => x.FileData)
> > > > .CustomSqlTypeIs("varbinary(MAX)");
> > > > }
> > > > }
>
> > > > I would like to conditionally specify the custom sql type for the
> > > > FileData property. When testing, I would like to use SqlLite; thus, I
> > > > would need to use BLOB as the sql type since SqlLite does not support
> > > > the varbinary(MAX) sql type. However, in production, I would like to
> > > > keep the mapping above. Is there a way to do this in a clean way? I
> > > > came across a blog where ActiveRecord is used, allowing you to plug
> > > > into the initialization pipeline. However, I'm not using
> > > > ActiveRecord. Is there some similar event model I can look into?
>
> > > > Thanks for any insights!- Hide quoted text -
>
> > > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To post to this group, send email to fluent-nhibernate@googlegroups.com
To unsubscribe from this group, send email to
fluent-nhibernate+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/fluent-nhibernate?hl=en
-~----------~----~----~----~------~----~------~--~---
