How do I convert a FileInfo.Attrib utes to a SqlDBType

[Greg Larsen]

I'm trying write a SQLCLR that returns FileInfo.Attrib utes property to SQL
Server in a record set and I am getting the following error.

cannot convert from 'System.IO.File Attributes' to
'System.Data.Sq lTypes.SqlInt32 '

How can I convert the Attributes to display an integer value. Clearly the
code below doesn't work. What do I need to do to make it work?

FileInfo f = new FileInfo(FileIn fo);
SqlMetaData Attributes;
Attributes = new SqlMetaData("At tributes", SqlDbType.Int);
record = new SqlDataRecord(n ew SqlMetaData[] { Attributes });
record.SetSqlIn t32(0,f.Attribu tes);

[Nicholas Paldino [.NET/C# MVP]]

Greg,

You can just cast the enumeration value, like so:

record.SetSqlIn t32(0, (int) f.Attributes);

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Greg Larsen" <Gr********@dis cussions.micros oft.com> wrote in message
news:EC******** *************** ***********@mic rosoft.com...

I'm trying write a SQLCLR that returns FileInfo.Attrib utes property to SQL
Server in a record set and I am getting the following error.

cannot convert from 'System.IO.File Attributes' to
'System.Data.Sq lTypes.SqlInt32 '

How can I convert the Attributes to display an integer value. Clearly the
code below doesn't work. What do I need to do to make it work?

FileInfo f = new FileInfo(FileIn fo);
SqlMetaData Attributes;
Attributes = new SqlMetaData("At tributes", SqlDbType.Int);
record = new SqlDataRecord(n ew SqlMetaData[] { Attributes });
record.SetSqlIn t32(0,f.Attribu tes);

[Greg Larsen]

That worked great. Thanks.

"Nicholas Paldino [.NET/C# MVP]" wrote:

Greg,

You can just cast the enumeration value, like so:

record.SetSqlIn t32(0, (int) f.Attributes);

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard. caspershouse.co m

"Greg Larsen" <Gr********@dis cussions.micros oft.com> wrote in message
news:EC******** *************** ***********@mic rosoft.com...

I'm trying write a SQLCLR that returns FileInfo.Attrib utes property to SQL
Server in a record set and I am getting the following error.

cannot convert from 'System.IO.File Attributes' to
'System.Data.Sq lTypes.SqlInt32 '

How can I convert the Attributes to display an integer value. Clearly the
code below doesn't work. What do I need to do to make it work?

FileInfo f = new FileInfo(FileIn fo);
SqlMetaData Attributes;
Attributes = new SqlMetaData("At tributes", SqlDbType.Int);
record = new SqlDataRecord(n ew SqlMetaData[] { Attributes });
record.SetSqlIn t32(0,f.Attribu tes);