RE: creating entities from rows instead of columns

[GregAtGregLowDotCom]

Hi Kirsten,

 

Do you just mean something like:

 

SELECT PropertyType,

  MAX(CASE WHEN Attribute = 'Name' THEN Value END) 

    AS Name,

  MAX(CASE WHEN Attribute = 'Age' THEN Value END) 

    AS Age,

  MAX(CASE WHEN Attribute = 'Haircolour' THEN Value END) 

    AS Haircolour

FROM dbo.Properties

GROUP BY PropertyType;

 

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:  <http://www.sqldownunder.com/> www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Kirsten Greed
Sent: Monday, 16 December 2013 10:00 AM
To: 'ozDotNet'
Subject: creating entities from rows instead of columns

 

Hi All

I have a table called Properties with fields

 

PropertyName nVarchar(80)

PropertyValue nVarchar(max)

PropertyType int

 

I want to be able to create an entity from it, similar to the way Entity
Framework creates entities from table definitions.

 

Are there any tools out there to do this?

Thanks

Kirsten