tags:

views:

27

answers:

0
Q: 

How can I use subsonic build a query?

MY SQL： Select isnull(Max(substring(ProductId,7,4)),0) As Pid From Product where substring(ProductId,1,6)='201004'

How can I use subsonic build a query?

related questions

SubSonic "Version" fails due to missing dependencies
Class usage in ORM based projects
SubSonic Problem Stored Procedures
SubSonic Collection Top 1
SubSonic Controller
jQuery Autocomplete and ASP.NET
Subsonic Join issue
SubSonic build errors
Subsonic\ORM on Windows CE\Mobile
Stored procedures or inline queries?
data access layer - subsonic, C# 2.0
What would you choose for your data layer today, Linq or Subsonic?
Subsonic: Comparing two columns instead of an input parameter
Generic contraints on derived classes
SubSonic and Stored Procedures
For those of you using SubSonic, what kind of performance are you seeing in large applications?
Quick/Easy generation of CRUD pages & Data Access Layer in CMS
SubSonic SubSonic.SqlQuery & Dates
Subsonic and sp_help_job
Using Subsonic for potentially heavily accessed ASPNET MVC Application
Are there any tips/tricks about using Subsonic with Asp.Net MVC Framework?
How Do I Load an Assembly and All of its Dependencies at Runtime in C# for Reflection?
SqlServer Express slow performance
Open Source Licensing Options for ASP.NET MVC Application?
Subsonic Vs NHibernate