tags:

views:

5

answers:

0
Q: 

Excluding a blob column from active record/linq query results

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.

related questions

Subsonic 3 Active Record Testing
Is there any demo to insert a new record into a table with identity primary key using Subsonic 3?
Subsonic SimpleRepository problem with Category.All
Problem with RunMigrations in SimpleRepository Example - Subsonic 3
Subsonic 3, MySQL T4 template: Structs.tt fails
SubSonic 3 ActiveRecord generated code with warnings
subsonic 3 scaffolding
Subsonic 3.0 SP parameter error
SQL Views in SubSonic 3.0
Defining SubSonic 3 ActiveRecord migrations
Is my IQueryable syntax correct?
Subsonic 3 Union Possible?
Create Foreign Key to ASP.Net Roles table
Does Subsonic 3 ActiveRecord Handle Many To Many Relationships?
Is there a way to generically return all of the records from a table with the Entity Framework
Is Subsonic 3.0 safe for production use?
Subsonic 3 SVN Checkout and T4
Subsonic 3/ASP.net MVC issue trying to override class column properties
NULL ForeignKeyTo property in Subsonic 3/ASP.NET MVC?
Subsonic 3/ASP.net mvc trying to save a null value in a datetime column
Which SubSonic 3 template to use
Subsonic 3 State
Subsonic3 & GUIDs
Subsonic 3 - Namespace hidden - Probably me!
Inserting a new record pattern in SubSonic 3