On Sep 8, 9:53 am, jmcqk6 <[email protected]> wrote: > Hello, > > I've been prototyping a process where I use Ruby to store and create > my database (and insert some default data). Since my main application > uses .NET and the entity framework and will be deployed with SQL > Server, I've used sequel.ado to connect, which is working perfectly to > read information. The problems turn up when I try to use > create_table: > > db.create_table :Categories do > primary_key :id > String :name > end > > db.create_table :Items do > primary_key :id > String :name, :unique => true, :null => false > foreign_key :category_id, :categories, :key=>:id > end > > This code runs successfully and generates the tables columns and > relationships correctly, which is great. The problem is that > *everything* is capitalized; table names and column names. While I > can go in and fix this, that sort of defeats the purpose. I've poked > around in the sequel documentation and this list archives, but I've > not been able to discover why. I suspect it's either something > related to this framework. Is there some way to change this behavior?
Sequel's default behavior on MSSQL is to capitalize identifiers going in and lowercase them going out. You probably want: DB.identifier_input_method = nil DB.identifier_output_method = nil Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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/sequel-talk?hl=en.
