CCNet.Build.SetupPackages.NuGetDb.GetLatestVersions C# (CSharp) Méthode

		public List<NuGetPackage> GetLatestVersions()
		{
			var result = new List<NuGetPackage>();

			using (var conn = new SqlConnection(m_connectionString))
			{
				conn.Open();

				using (var cmd = conn.CreateCommand())
				{
					cmd.CommandText =
						@"
SELECT MAX([Key]) AS LatestKey
INTO #Latest
FROM Packages WITH(NOLOCK)
GROUP BY PackageRegistrationKey

SELECT
	PR.Id,
	P.Tags,
	P.Title,
	P.[Version],
	PF.TargetFramework
FROM #Latest T
	INNER JOIN Packages P WITH(NOLOCK)
	ON P.[Key] = T.LatestKey
	INNER JOIN PackageRegistrations PR WITH(NOLOCK)
	ON PR.[Key] = P.PackageRegistrationKey
	INNER JOIN PackageFrameworks PF WITH(NOLOCK)
	ON PF.[Key] = P.[Key]

DROP TABLE #Latest
						";

					using (var reader = cmd.ExecuteReader())
					{
						while (reader.Read())
						{
							var id = reader.ReadString("Id");
							var version = reader.ReadString("Version");
							var framework = reader.ReadString("TargetFramework");
							var title = reader.ReadStringOrNull("Title");
							var tags = reader.ReadStringOrNull("Tags");

							var package = new NuGetPackage(id, version, framework, title, tags);
							result.Add(package);
						}
					}
				}
			}

			return result;
		}
	}

        public NuGetSubstitute(string nugetDbConnection)
        {
            m_db = new NuGetDb(nugetDbConnection);

            m_thisBranchPackages = m_db.GetLatestVersions()
                                   .Where(p => p.Branch == Args.BranchName.ToLower())
                                   .ToList();
        }