public static UserDataProvider GetUserFromUserName(string userName)
{
using (SqlConnection connection = ConnectionManager.GetConnection())
{
var data = new ActivEarthDataProvidersDataContext(connection);
return data.UserDataProviders.FirstOrDefault(u => u.user_name == userName);
}
}