We have a webapp where each client has their own db (approx. 700 at the moment). In SubSonic 2, you had to wrap each call with the SharedDBConnectionScope passing in the right connection string to u
Let\'s say I have a the following query: int x = 5; var result = from p in db.products where p.CategoryId == x
I was not able to insert data into table with computed column using Subsoni开发者_Python百科c. Is it well-known bug? And how I can to resolve it?This is the code SubSonic runs against the db to determ
I\'m having a little trouble with a query. In my database datetimes are stored as YYYY-MM-dd HH:mm:ss
Have 2 MySQL databases. One is the main database, the other is used for geolocation data. Now, for SubSonic to play nice with the generated files via Subcommander, I made it easy and just created a vi
I have a website project that was written with subsonic though m开发者_如何学Cedium trust hosting services like GoDaddy and AT&T don\'t support subsonic projects.
UPDATE 开发者_JAVA技巧 Scenarios.Blocks SETOrderId = OrderId - 1 So, it\'s basically updating a column with its current value minus one.This should help:
when generating an activerecord.cs from mysql using subsonic, some foreign keys are overlooked by the template. it acknowledges the table and columns, just not the relations.
I have begun using SubSonic and I am wondering how to get it to ignore DateTime properties on insert. I am using the ActiveRecord template and have default methods to create the datetime properties on
I am still reasonably new to subsonic and finding the simplest things a little tricky. I have a simple query that joins two tables, Profile and Subscription.