hello-entity-framework-1

UserService.cs

public class UserService
{
    public IEnumerable<User> GetUsers()
    {
        var ds = new DataSet();

        using (var con = new SqlConnection("Server=myServerAddress;Database=myDataBase;UserId=myUsername;Password=myPassword;"))
        {
            using (var da = new SqlDataAdapter("SELECT * FROM Users", con))
            {
                da.Fill(ds);
            }
        }

        if (ds.Tables.Count == 0)
            return new User[] { };
        return ds.Tables[0].Rows.Cast<DataRow>().Select(x => new User
        {
            Id = (long) x["ID"],
            Username = (string) x["Username"],
            Password = (string) x["Password"]
        });
    }
}