Excluding a blob column from active record/linq query results

295 Views Asked by At

What's the easiest way to exclude a column from the result set in a Subsonic/ActiveRecord/Linq query?

I've a got a table of images, and often I only want the meta data associated with the image (image id/name/dimensions for example). Seems fairly wasteful to be pulling in the entire image data for these requests.

My current thought is to split out the image data to a separate table, but I'm wondering if there's an easier/better way.

1

There are 1 best solutions below

1
On

As You can see in the docs via the link below its possible to use LINQ and detail your query that way.

http://subsonicproject.com/docs/Using_ActiveRecord