using System.Collections.Generic;
using System.Data.SqlClient;
public string ConnectionString = "Data Source=(local);Initial Catalog=User;";
public List<User> GetUsersFromUsernames(List<string> usernames)
var list = new List<User>();
foreach (var username in usernames)
SqlConnection conn = new SqlConnection(this.ConnectionString);
var cmd = new SqlCommand("SELECT FirstName, LastName, Email FROM [User] WHERE Username = '" + username + "'", conn);
cmd.CommandType = System.Data.CommandType.Text;
SqlDataReader rdr = cmd.ExecuteReader();
FirstName = rdr.GetString(0),
LastName = rdr.GetString(1),
public string FirstName { get; set; }
public string LastName { get; set; }
public string Email { get; set; }