Jeremy, this worked perfectly. Thanks for the quick response! I appreciate it!
Josh On Wed, Sep 8, 2010 at 12:46 PM, Jeremy Evans <[email protected]> wrote: > 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. > > -- 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.
