public static ResultModel GetConnectionString(Rayvarz.Systems.Catalog Cat = Rayvarz.Systems.Catalog.RAYVARZ)
{
try
{
Rayvarz.Systems.Properties.Connections.ConnectionsManager cmg =
new Rayvarz.Systems.Properties.Connections.ConnectionsManager(Rayvarz.Systems.Catalog.RAYVARZ);
var connectionsPath = (Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Rayvarz\\Connection\\Connections.xml");
cmg.SetConnectionFromSourcePath(connectionsPath);
var C = ((SqlConnection)cmg.Get_CheckDefaultCnString(Cat));
System.Reflection.PropertyInfo property = C.GetType().GetProperty("ConnectionOptions", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic);
var optionsObject = property.GetValue(C, null);
System.Reflection.MethodInfo method = optionsObject.GetType().GetMethod("UsersConnectionString");
string connStr = method.Invoke(optionsObject, new object[] { false }) as string; // argument is "hidePassword" so we set it to false
return new ResultModel(connStr);
}
catch (Exception Err)
{
return new ResultModel(Err);
}
}
public static ResultModel GetConnectionString(Rayvarz.Systems.Catalog Cat = Rayvarz.Systems.Catalog.RAYVARZ)
{
try
{
Rayvarz.Systems.Properties.Connections.ConnectionsManager cmg =
new Rayvarz.Systems.Properties.Connections.ConnectionsManager(Rayvarz.Systems.Catalog.RAYVARZ);
var connectionsPath = (Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + "\\Rayvarz\\Connection\\Connections.xml");
cmg.SetConnectionFromSourcePath(connectionsPath);
var C = ((SqlConnection)cmg.Get_CheckDefaultCnString(Cat));
System.Reflection.PropertyInfo property = C.GetType().GetProperty("ConnectionOptions", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic);
var optionsObject = property.GetValue(C, null);
System.Reflection.MethodInfo method = optionsObject.GetType().GetMethod("UsersConnectionString");
string connStr = method.Invoke(optionsObject, new object[] { false }) as string; // argument is "hidePassword" so we set it to false
return(new ResultModel(connStr));
}
catch (Exception Err)
{
return(new ResultModel(Err));
}
}
