subsonic
Connections with many databases
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[详细]
2023-01-30 19:25 分类:问答subsonic - convert an linq query to sql query / DataReader
Let\'s say I have a the following query: int x = 5; var result = from p in db.products where p.CategoryId == x[详细]
2023-01-30 17:45 分类:问答Computed Columns in SQL Server with Subsonic
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[详细]
2023-01-29 23:50 分类:问答Subsonic 3.0 ActiveRecord with dates
I\'m having a little trouble with a query. In my database datetimes are stored as YYYY-MM-dd HH:mm:ss[详细]
2023-01-29 20:37 分类:问答SubSonic: MySql, Float, and Single->Decimal issues
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[详细]
2023-01-29 07:00 分类:问答Are there any credible shared hosting services that are compatible with subsonic projects?
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.[详细]
2023-01-28 14:22 分类:问答How to write this sql query with SubSonic3?
UPDATE 开发者_JAVA技巧 Scenarios.Blocks SETOrderId = OrderId - 1 So, it\'s basically updating a column with its current value minus one.This should help:[详细]
2023-01-27 09:16 分类:问答Foreign keys not recognised
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.[详细]
2023-01-25 13:48 分类:问答How can I allow sql to set datetime with subsonic
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[详细]
2023-01-25 06:42 分类:问答Subsonic 2.2 Binding joined table columns to a grid
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.[详细]
2023-01-25 03:27 分类:问答