C# (CSharp) CCNet.Build.SetupPackages NuGetPackage Exemples

Exemple #1

        private void InstallNuGutPackage(NuGetPackage package, string branchNuGetUrl)
        {
            var downloadUrl = $"{branchNuGetUrl}/package/__{package.Branch.ToLower()}__{package.Id}/{package.Version}";
            var packageName = $"{Args.PackagesPath}\\{package.Id}.{package.Version}\\{package.Id}.{package.Version}.nupkg";

            ClearPackage(packageName);
            (new WebClient()).DownloadFile(downloadUrl, packageName);
            UnZipPackage(packageName);
        }

Exemple #2

        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);
        }

Exemple #3

Fichier : NuGetDb.cs Projet : shuruev/CCNet.Extensions

		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;
		}