LINQ Varbinary to C# Byte Array

Question

I am new to the whole LINQ system, i have my passwords hashed and stored in a varbinary field in my database, now i want to get that value from my database and store it in a byte array to do a comparison using LINQ. I did it like this before:

System.Data.SqlTypes.SqlBytes sqlPassBinary = dr.GetSqlBytes(dr.GetOrdinal("Password"));

Now i want to try and apply this same concept but using LINQ this time. I tried this but it didn't work:

public bool Authenticate(string user, string pass)
{
    ***LINQDataContext d = new ***LINQDataContext();

    var login = from us in d.Users
                join ur in d.UserRoles on us.UserRoleID equals ur.UserRoleID
                where us.Username == user 
                select us;

    if ((login as IEnumerable<object>).Any())
    {
        System.Web.HttpContext.Current.Session["UserID"] = login.FirstOrDefault().UserID.ToString();
        System.Web.HttpContext.Current.Session["UserRole"] = login.FirstOrDefault().UserRole.ToString();
        byte[] sqlbinary = (byte[]) login.FirstOrDefault().Password;;

        return true;
    }

    return false;
}

And i get this error: enter image description here

what is login? you need to show a full code example with all your members. — Yuval Itzchakov
– Yuval Itzchakov, Commented May 14, 2014 at 9:49
"it didn't work" tells us very little about what actually happened. Did it fail to compile? Did it compile but give an execution-time exception? Did it silently give you incorrect data? Please give more information. (Think about what you'd want to know if someone came to you with the question and asked you to help solve it.) — Jon Skeet
– Jon Skeet, Commented May 14, 2014 at 9:50

Kamil T · Accepted Answer · 2014-05-14 10:53:20Z

6

This error indicates that the collection returned by LINQ is a System.Data.Linq.Binary object and you cannot use it to initialize the byte[], nor to convert it explicitly.

First, you need to convert it to the array, use the LINQ's built-in ToArray() function.

Use

byte[] sqlbinary = login.FirstOrDefault().Password.ToArray();

It should be just fine.

edited May 14, 2014 at 10:53

answered May 14, 2014 at 9:55

Kamil T

2,2161 gold badge19 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

LINQ Varbinary to C# Byte Array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related