32?? ???????? 64?? ?????? ???

??: 32?? ??????? ?? ?? SQL Server ???? ?? ??? ???? ?? 64?? ????? ?? ????? ?? ??? ????. ??? ????? Wow6432Node ??

???: Windows 7 ????? .NET Framework 4.x ??? ?? 64?? ????? ?? ????? ?? ?? ??? ?????. ??? RegistryView ???? ???? ????:

• RegistryView.Registry64: 64?? ?????? ??????.
• RegistryView.Registry32: 32?? ?????? ??????.

?? ?(?? 64?? ???):

? ?? ??? 64?? ?????? ?? ?? ???? ?????.

using Microsoft.Win32;

RegistryKey localKey = RegistryKey.OpenBaseKey(RegistryHive.LocalMachine, RegistryView.Registry64);
RegistryKey sqlServerKey = localKey.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL");
string sqlExpressKeyName = (string)sqlServerKey.GetValue("SQLEXPRESS"); 

?? ??? ?? ??(??? ??):

? ? ???? ?? ??? ??? ??? 32?? ? 64?? ?????? ?? ???? ??? ?????.

using Microsoft.Win32;
using System.Collections.Generic;
using System.Linq;

public static IEnumerable<string> GetAllRegValueNames(string RegPath, RegistryHive hive = RegistryHive.LocalMachine)
{
    var reg64 = GetRegValueNames(RegistryView.Registry64, RegPath, hive);
    var reg32 = GetRegValueNames(RegistryView.Registry32, RegPath, hive);
    var result = (reg64 != null && reg32 != null) ? reg64.Union(reg32) : (reg64 ?? reg32);
    return (result ?? new List<string>().AsEnumerable()).OrderBy(x => x);
}

public static object GetRegValue(string RegPath, string ValueName = "", RegistryHive hive = RegistryHive.LocalMachine)
{
    return GetRegValue(RegistryView.Registry64, RegPath, ValueName, hive) ?? GetRegValue(RegistryView.Registry32, RegPath, ValueName, hive);
}

private static IEnumerable<string> GetRegValueNames(RegistryView view, string regPath, RegistryHive hive)
{
    try
    {
        using (var key = RegistryKey.OpenBaseKey(hive, view).OpenSubKey(regPath))
        {
            return key?.GetValueNames();
        }
    }
    catch (Exception) { return null; }
}

private static object GetRegValue(RegistryView view, string regPath, string valueName, RegistryHive hive)
{
    try
    {
        using (var key = RegistryKey.OpenBaseKey(hive, view).OpenSubKey(regPath))
        {
            return key?.GetValue(valueName);
        }
    }
    catch (Exception) { return null; }
}

??? ?? ??:

? ???? ??? ??? ?????.

var sqlRegPath = @"SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL";
foreach (var valueName in GetAllRegValueNames(sqlRegPath))
{
    var value = GetRegValue(sqlRegPath, valueName);
    Console.WriteLine($"{valueName}={value}");
}

? ??? ?? ??? ???? ??? ???? ?????? ?? ????? ?? ????? ???? ????? ??? ????? ?? ?? ??? ???? ?????.

? ??? 32?? ?? ????? 64?? Windows ?????? ??? ???? ? ?????? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!