public EmployeeRecord GetEmployeeById(string resourceId) { EmployeeRecord emp = new EmployeeRecord(); using (SqlConnection conn = new SqlConnection("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux")) { conn.Open(); string cmdStr = String.Format("Select firstname,lastname from vEmployee where ResourceId=" + resourceId); SqlCommand cmd = new SqlCommand(cmdStr, conn); SqlDataReader rd = cmd.ExecuteReader(); if (rd.HasRows) { rd.Read(); emp.firstname = rd.GetString(0); emp.lastname = rd.GetString(1); } conn.Close(); return emp; } }
//test public EmployeeRecord GetEmployee() { EmployeeRecord emp = new EmployeeRecord(); DataClassesDataContext ctx = new DataClassesDataContext("Data Source=AIP-SQLAIPL;Initial Catalog=Aipl;User ID=ambiflux;Password=ambiflux"); return (from e in ctx.vEmployee where e.ResourceID == 3 select new EmployeeRecord { firstname = e.FirstName, lastname = e.LastName }).SingleOrDefault(); }