Yeah, this quoting thing it's an issue too when using things like Formulas and/or Checks..
Specially on PostgreSQL which is case sensitive when using quotes, but insensitive when not. This forces us to quote every identifier on each formular definition, but then NH get's confused and makes weird things like this: Formula: "(SELECT SUM(b.`Credit`) FROM `BusinessUnits` b WHERE b.`OwnerId`=`Id`)" Result: (SELECT SUM(b.this_."Credit") FROM this_."BusinessUnits" b WHERE b.this_."OwnerId"=this_."Id") W/o quoting tables/columns there's no need to quote identifiers on formulas.. and so there's no problem at all. Initally I thoung on adding some kind of global property to FluentConfiguration which disabled quoting at all, but AFAIK from XmlColumnWriter you cannot access FluentConfiguration nor any other global structure.. so I have nothing on which I can really to know if the user wants quoting or not. On Jan 23, 9:10 pm, Doron Yaacoby <[email protected]> wrote: > Sure thing. Thanks for the tip. > > On Jan 23, 10:08 pm, James Gregory <[email protected]> wrote: > > > > > Looks like I need to review this again then. In the mean time you'll need to > > modify the code yourself to undo my change :( > > > XmlColumnWriter is the class you need to change, you should see the code for > > writing out the name attribute appends the backticks. > > > I'll try to come up with a more manageable solution; maybe a setting or > > something. > > > On Sat, Jan 23, 2010 at 8:03 PM, Doron Yaacoby <[email protected]> wrote: > > > Well, > > > In Oracle quoting a table or a column name makes it case-sensitive. > > > So select * from "Customer" != select * from customer. Hence, the > > > failing queries. > > > > I also noticed that FNHquotestable names as well, but that can be > > > overcome by explicitly specifing the table name in the mappings. It > > > doesn't work for columns, though. > > > > On Jan 23, 9:48 pm, James Gregory <[email protected]> wrote: > > > > Your queries shouldn't fail, unless oracle is really badly designed. The > > > > quoting simply affects the queries, and is used to escape keywords. At > > > least > > > > in SQL Server [Customer] is exactly the same as Customer in a query, and > > > has > > > > no effect to the underlying schema. > > > > > On Sat, Jan 23, 2010 at 7:28 PM, Doron Yaacoby <[email protected]> > > > wrote: > > > > > Since all my queries now fail, as my tables in the database (Oracle) > > > > > were created withoutquotesin the field names. Is there a way to turn > > > > > the quoting off? > > > > > > On Jan 23, 9:22 pm, James Gregory <[email protected]> wrote: > > > > > > Yep, by design. Why? > > > > > > > On Sat, Jan 23, 2010 at 7:21 PM, Doron Yaacoby <[email protected]> > > > > > wrote: > > > > > > > Hi, > > > > > > > Using the latest trunk version of FNH, it seems to be quoting all > > > > > > > field names in the mappings. This doesn't happen in the version 1 > > > RTM. > > > > > > > Is this by design? > > > > > > > > Thanks, > > > > > > > Doron > > > > > > > > -- > > > > > > > You received this message because you are subscribed to the Google > > > > > Groups > > > > > > > "Fluent NHibernate" group. > > > > > > > To post to this group, send email to > > > > > [email protected]. > > > > > > > To unsubscribe from this group, send email to > > > > > > > [email protected]<fluent-nhibernate%2Bunsubscr > > > > > > > [email protected]> > > > <fluent-nhibernate%[email protected]<fluent-nhibernate%252Buns > > > [email protected]> > > > > > > <fluent-nhibernate%[email protected]<fluent-nhibernate%252Buns > > > > > [email protected]> > > > <fluent-nhibernate%[email protected]<fluent-nhibernate%25252 > > > [email protected]> > > > > > > > > . > > > > > > > For more options, visit this group at > > > > > > >http://groups.google.com/group/fluent-nhibernate?hl=en. > > > > > > -- > > > > > You received this message because you are subscribed to the Google > > > Groups > > > > > "Fluent NHibernate" group. > > > > > To post to this group, send email to > > > [email protected]. > > > > > To unsubscribe from this group, send email to > > > > > [email protected]<fluent-nhibernate%2Bunsubscr > > > > > [email protected]> > > > <fluent-nhibernate%[email protected]<fluent-nhibernate%252Buns > > > [email protected]> > > > > > > . > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/fluent-nhibernate?hl=en. > > > > -- > > > You received this message because you are subscribed to the Google Groups > > > "Fluent NHibernate" group. > > > To post to this group, send email to [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]<fluent-nhibernate%2Bunsubscr > > > [email protected]> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/fluent-nhibernate?hl=en. -- You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en.
