Converting a piece of code from VB to C#

A Year or so I wrote a piece of code in VB to allow me to have an array of objects that could be tested to sse if they existed i.e. not null. I am trying to convert this to C#. I have got the conversion this far.

    public class DataServices
    {
        public static T? Coalesce<T>(T Obj, params T[] Args)      
        {
            if (Obj != null && IsDBNull(Obj))
            {
                return Obj;
            }
            else 
            {
                foreach (T arg in Args )
                {
                    if (arg != null && IsDBNull(arg)) return arg; 
                }
            }
            return null;
         }

        public static Boolean IsDBNull(Object Value)
        {
            return DBNull.Value.Equals(Value);  
        }
    }

Open in new window

The original looked like this.

 Public Shared Function Coalesce(Of T)(ByVal obj As T, ByVal ParamArray Args() As T) As T

        If obj IsNot Nothing AndAlso Not IsDBNull(obj) Then
            Return obj
        End If

        For Each arg As T In Args
            If arg IsNot Nothing AndAlso Not IsDBNull(obj) Then
                Return arg
            End If
        Next

        Return Nothing
    End Function

Open in new window

The error I am getting is

Error 1 The type 'T' must be a non-nullable value type in order to use it as parameter 'T' in the generic type or method 'System.Nullable<T>' C:\Users\carl.symington\Documents\Visual Studio 2012\Projects\DataServices\DataServices\DataServices.cs 11 26 DataServices

I suspect it is to do with where I have tried to put T? making T a nullable object.

public static T Coalesce<T>(T Obj, params T[] Args) { if (Obj != null && IsDBNull(Obj)) { return Obj; } else { foreach (T arg in Args ) { if (arg != null && IsDBNull(arg)) return arg; } } return null; }

public static T Coalesce<T>(T obj, params T[] Args) { if (obj != null && !Information.IsDBNull(obj)) { return obj; } foreach (T arg in Args) { if (arg != null && !Information.IsDBNull(obj)) { return arg; } } return null; }

public class DataServices { public static T Coalesce<T>(T Obj, params T[] Args) { if (Obj != null && IsDBNull(Obj)) { return Obj; } else { foreach (T arg in Args ) { if (arg != null && IsDBNull(arg)) return arg; } } return null; } public static Boolean IsDBNull(Object Value) { return DBNull.Value.Equals(Value); } }

public static T Coalesce<T>(T obj, params T[] args) { if (obj != null) return obj; foreach (T arg in args) { if (arg != null) return arg; } return default(T); }

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 15

Lokesh B RDeveloperCommented: 2015-06-11

Hi,

LVL 1

AlyantoAuthor Commented: 2015-06-11

Lokesh this causes the error

Error 1 Cannot convert null to type parameter 'T' because it could be a non-nullable value type. Consider using 'default(T)' instead. C:\Users\carl.symington\Documents\Visual Studio 2012\Projects\DataServices\DataServices\DataServices.cs 24 20 DataServices

Just to be clear the C# version of IsDBNull is

        public static Boolean IsDBNull(Object Value)
        {
            return DBNull.Value.Equals(Value);  
        }

Hi,

This is the code i get when converted from VB to C#

LVL 72

Éric MoreauSenior .Net ConsultantCommented: 2015-06-11

by definition, an object can be null so it doesn't need the ? (as opposed to date, int, ...). I think you just need to remove it

Eric the code that you suggested gives this error

You also need to change (as indicated by the error)

return null;

for

return default(T);

so the fuil method would read:

for details on "default", check https://msdn.microsoft.com/en-us/library/xwth0h0d(VS.80).aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

Excellent solution Eric, you have no idea how useful I have found a proper Coalese has been in a tight corner.

Converting a piece of code from VB to C#

Who is Participating?