I have a table that looks like this:
CREATE TABLE ref_documents(
document_id int IDENTITY(1,1),
descriptions xml NOT NULL,
doc_type nvarchar(20) NOT NULL,
is_external tinyint NOT NULL
CHECK (is_external in (0, 1)),
external_path nvarchar(200) NULL,
data varbinary(max) NULL,
comments nvarchar(2000) NULL,
is_active tinyint NOT NULL
CHECK (is_active in (0, 1)),
CONSTRAINT pk_rf_doc PRIMARY KEY CLUSTERED (document_id)
)
I want to ensure that the "data" column is not loaded unless I explicitly reference it.
I can mark the property (in the mapping) to be lazy load, but cannot see how to mark an individual column in LLBLGen Pro (V4.2).
Is this possible? If not, I think this would be a great feature. I have a number of similar tables and this would be a big help.
Thanks.