How do I convert a FileInfo.Attributes to a SqlDBType

[Guest]

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

cannot convert from 'System.IO.FileAttributes' to
'System.Data.SqlTypes.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(FileInfo);
SqlMetaData Attributes;
Attributes = new SqlMetaData("Attributes", SqlDbType.Int);
record = new SqlDataRecord(new SqlMetaData[] { Attributes });
record.SetSqlInt32(0,f.Attributes);

 

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

Greg,

You can just cast the enumeration value, like so:

record.SetSqlInt32(0, (int) f.Attributes);

Hope this helps.

 

[Guest]

That worked great. Thanks.

Greg,

You can just cast the enumeration value, like so:

record.SetSqlInt32(0, (int) f.Attributes);

Hope this helps.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

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

cannot convert from 'System.IO.FileAttributes' to
'System.Data.SqlTypes.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(FileInfo);
SqlMetaData Attributes;
Attributes = new SqlMetaData("Attributes", SqlDbType.Int);
record = new SqlDataRecord(new SqlMetaData[] { Attributes });
record.SetSqlInt32(0,f.Attributes);