SchemaZen.Library.Models.SqlAssembly.ScriptCreate C# (CSharp) Метод

		public string ScriptCreate() {
			var commands =
				Files.Select(
					(kvp, index) =>
						string.Format("{0} ASSEMBLY [{1}]\r\n{2}FROM {3}\r\n{4}", index == 0 ? "CREATE" : "ALTER", Name,
							index == 0 ? string.Empty : "ADD FILE ", "0x" + new SoapHexBinary(kvp.Value).ToString(),
							index == 0 ? "WITH PERMISSION_SET = " + PermissionSet : string.Format("AS N'{0}'", kvp.Key)));
			var script = string.Join("\r\nGO\r\n", commands.ToArray());
			return script;
		}

        public void Assembly_WithPermissionSetCases(string permissionSet, string scriptedPermissionSet) {
            var assembly = new SqlAssembly(permissionSet, "SchemazenAssembly");
            assembly.Files.Add(new KeyValuePair<string, byte[]>("mydll", new byte[0]));

		    var expected = @"CREATE ASSEMBLY [SchemazenAssembly]
FROM 0x
WITH PERMISSION_SET = " + scriptedPermissionSet;
		    Assert.AreEqual(expected, assembly.ScriptCreate());
		}