How to Show RECORDS from SQL2005 to C# into XML Format

Hi, 
I have stored procedure in SQL 2005
create procedure [dbo].[XMLRead]
(
@value bigint
)
as
select p.productname,dc.DimensionCategoryname,dn.DimensionName,dv.DimensionValuename
from Product_Dimension pd
inner join Product p on p.ProductID=pd.FKProductID
inner join DimensionCategory dc on pd.FkDimensionCategoryID = dc.DimensionCategoryID
inner join DimensionName dn on pd.FKDimensionNameID =dn.DimensionNameID
inner join DimensionValue dv on pd.FKDimensionValueID=dv.DimensionValueID
for xml path('RECORDS'),ROOT('RECORD')
This query returns folowing XML
<RECORDs>
<RECORD>
<productname>StylishShoes</productname>
<DimensionCategoryname>Men</DimensionCategoryname>
<DimensionName>Color</DimensionName>
<DimensionValuename>Black</DimensionValuename>
</RECORD>
<RECORD>
<produ ...