Use a view instead of a table as source of data for MsSqlServer2008Provider

Topics: Data Access, SharpMap v2.0
Feb 20, 2010 at 6:54 PM

Can I set the TableName property to a View, instead of a table name to the MsSqlServer2008Provider?

In my view this is a fairly important feature because this will provide the ability to do joins on multiple tables and therefore making the attribute data flexible.

Feb 20, 2010 at 9:04 PM

Views are fine however you probably need to ensure that you have a single column key in the view. Compound keys are not supported. Hth jd

Feb 21, 2010 at 5:46 AM

Hi John,

How about Stored Procs? That would bring unlimited possibilities onto the table!


Feb 21, 2010 at 9:57 AM

Hi Raghu, unfortunately SPs and db functions are not supported as there is no reliable way of mapping parameters.  cheers jd