internal static TestPackageVersionData Select(int testPackageID) { TestPackageVersionData result = null; string connectionString = ConfigurationManager.ConnectionStrings["SQLConnectionString"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); using (SqlCommand command = new SqlCommand("[Definition].[TestPackageVersion_Select]", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@pTestPackageID", testPackageID); var reader = command.ExecuteReader(); if (reader.Read()) { result = FromData(reader); } reader.Close(); } } return(result); }
private static TestPackageVersionData FromData(IDataReader reader) { TestPackageVersionData instance = new TestPackageVersionData(); instance.TestPackageID = reader.GetInt32(0); instance.TestPackageVersionID = reader.GetInt32(1); instance.TestPackagePath = reader.GetString(2); return(instance); }