How to get a list of all SQl Data Types on c#?

Question

Is there any way to get some list of all Sql Data Types on c#?

I know that we have a Enum called SQlDbType which contains all Sql Data Types, but can we convert an Enum to an array of strings?

I only want to get some list with all Sql Data Types, instead of writing them one by one and adding them into my array of strings.

possible duplicate of Convert Enum to String

Cheeso
– Cheeso

2011-02-12 11:43:11 +00:00
Commented Feb 12, 2011 at 11:43 — Cheeso
– Cheeso, Commented Feb 12, 2011 at 11:43

Jon Skeet · Accepted Answer · 2011-02-12 11:42:51Z

7

Enum to an array of strings is pretty easy:

var names = Array.ConvertAll((SqlDbType[]) Enum.GetValues(typeof(SqlDbType)),
                             type => type.ToString());

or using LINQ:

var names = Enum.GetValues(typeof(SqlDbType))
                .Cast<SqlDbType>()
                .Select(x => x.ToString())
                .ToArray();

Or more pleasantly using my Unconstrained Melody library, either as an array or (more efficiently) an immutable list:

string[] names = Enums.GetNamesArray<SqlDbType>();

IList<string> namesList = Enums.GetNames<SqlDbType>();

answered Feb 12, 2011 at 11:42

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get a list of all SQl Data Types on c#?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related