Featured post
database - Dataset constraints from DB .net 3.5 -
i have stored procedure in db returns different columns different conditions. (dynamic sql). when use sqlhelper class , execute stored proc in business layer, returns possible columns (from if/else conditions in dynamic sql) in dataset returned. other columns should not part of result set blank. columns come db constraints on them. every time use dataset have set "enforceconstraints" false. there better approach, 1) avoid bringing constraints db? or 2) required dynamic columns db?
thank you
are datatables being generates weakly or using typed datasets?
probably not want hear, advice have different sps different result sets. of inference of result sets e.g. datasets works off sp if sp can return different things based on supplied data, you'll start see issues you've seen.
- Get link
- X
- Other Apps
Comments
Post a Comment