How to use GetConnectionString method of NBi.Core.OfficeDataConnectionFileParser class

Best NBi code snippet using NBi.Core.OfficeDataConnectionFileParser.GetConnectionString

ConnectionStringHelper.cs

Source:ConnectionStringHelper.cs

...19        {20            var connectionString = GetBaseConnectionString(rawConnectionString, references, @default);21            //If it's an ODC file22            if (!string.IsNullOrEmpty(connectionString) && connectionString.TrimEnd().EndsWith(".odc"))23                return new OfficeDataConnectionFileParser(basePath).GetConnectionString(connectionString);24            //We must remove all the characters such as \r \n or \t25            if (!string.IsNullOrEmpty(connectionString))26                connectionString = connectionString.Replace("\r", "").Replace("\n", "").Replace("\t", "");27            if (!string.IsNullOrEmpty(roles))28                connectionString = ReplaceRoles(connectionString, roles);29            return connectionString;30        }31        private string ReplaceRoles(string connectionString, string newRoles)32        {33            var pattern = "Roles(\\s)*=(\\s)*(?<RolesValue>([^;]*))";34            var options = RegexOptions.IgnorePatternWhitespace | RegexOptions.Multiline | RegexOptions.IgnoreCase | RegexOptions.Compiled;35            var reg = new Regex(pattern, options);36            var match = reg.Match(connectionString);37            if (match.Success)...

OfficeDataConnectionFileParserTest.cs

Source:OfficeDataConnectionFileParserTest.cs

...13    public class OfficeDataConnectionFileParserTest14    {15        private const string ODC_FILE = "Sample.odc";16        [Test]17        public void GetConnectionString_ValidRelativeFile_CorrectConnectionString()18        {19            var fullPath = DiskOnFile.CreatePhysicalFile(ODC_FILE, "NBi.Testing.Integration.Core.Resources." + ODC_FILE);20            var parser = new OfficeDataConnectionFileParser(Path.GetDirectoryName(fullPath) + Path.DirectorySeparatorChar);21            var connectionString = parser.GetConnectionString(ODC_FILE);22            Assert.That(connectionString, Is.EqualTo("Provider=MSOLAP.7;Integrated Security=ClaimsToken;Identity Provider=AAD;Data Source=https://analysis.windows.net/powerbi/api;;Initial Catalog=sobe_wowvirtualserver-ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;Location=https://wabi-north-europe-redirect.analysis.windows.net/xmla?vs=sobe_wowvirtualserver&db=ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;MDX Compatibility= 1; MDX Missing Member Mode= Error; Safety Options= 2; Update Isolation Level= 2"));23        }24        [Test]25        public void GetConnectionString_ValidAbsoluteFile_CorrectConnectionString()26        {27            var fullPath = DiskOnFile.CreatePhysicalFile(ODC_FILE, "NBi.Testing.Integration.Core.Resources." + ODC_FILE);28            var parser = new OfficeDataConnectionFileParser(Path.GetDirectoryName(fullPath));29            var connectionString = parser.GetConnectionString(fullPath);30            Assert.That(connectionString, Is.EqualTo("Provider=MSOLAP.7;Integrated Security=ClaimsToken;Identity Provider=AAD;Data Source=https://analysis.windows.net/powerbi/api;;Initial Catalog=sobe_wowvirtualserver-ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;Location=https://wabi-north-europe-redirect.analysis.windows.net/xmla?vs=sobe_wowvirtualserver&db=ccdf3d76-59d9-4e10-83e8-82eb0d27d1e9;MDX Compatibility= 1; MDX Missing Member Mode= Error; Safety Options= 2; Update Isolation Level= 2"));31        }32        [Test]33        public void GetConnectionString_InvalidFile_FileNotFoundException()34        {35            var fullPath = DiskOnFile.CreatePhysicalFile(ODC_FILE, "NBi.Testing.Integration.Core.Resources." + ODC_FILE);36            var parser = new OfficeDataConnectionFileParser(Path.GetDirectoryName(fullPath) + Path.DirectorySeparatorChar);37            Assert.Throws<FileNotFoundException>(delegate { parser.GetConnectionString("NonExisting.odc"); });38        }39    }40}...

OfficeDataConnectionFileParser.cs

Source:OfficeDataConnectionFileParser.cs

...15        public OfficeDataConnectionFileParser(string basePath)16        {17            BasePath = basePath;18        }19        public string GetConnectionString(string path)20        {21            if (!Path.IsPathRooted(path))22                path = BasePath + path;23            if (!File.Exists(path))24                throw new FileNotFoundException(string.Format("Impossible to read the connection from odc file. The file '{0}' doesn't exist.", path));25            var text = File.ReadAllText(path);26            return GetConnectionStringFromText(text);27        }28        internal string GetConnectionStringFromText(string text)29        {30            var startConnectionTag = text.IndexOf("<odc:ConnectionString");31            if (startConnectionTag == -1)32                throw new InvalidDataException(string.Format("Impossible to read the connection from odc file. This file has no tag '<odc:connection>'. "));33            startConnectionTag = text.IndexOf(">", startConnectionTag)+1;34            var endConnectionTag = text.IndexOf("</odc:ConnectionString");35            var connectionString = text.Substring(startConnectionTag, endConnectionTag - startConnectionTag);36            return connectionString;37        }38    }39}...

GetConnectionString

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core;7using NBi.Core.Configuration;8using NBi.Core.Configuration.FailureReport;9using NBi.Core.Configuration.Serialization;10using NBi.Core.Decoration.IO;11using NBi.Core.Decoration.IO.Commands;12using NBi.Core.Decoration.IO.Commands.Files;13using NBi.Core.Decoration.IO.Commands.Text;14using NBi.Core.Decoration.IO.Commands.Xml;15using NBi.Core.Decoration.Process;16using NBi.Core.Decoration.Process.Commands;17using NBi.Core.Decoration.Process.Commands.Credential;18using NBi.Core.Decoration.Process.Commands.Elevate;19using NBi.Core.Decoration.Process.Commands.Text;20using NBi.Core.Decoration.Query;21using NBi.Core.Decoration.Query.Commands;22using NBi.Core.Decoration.Scalar;23using NBi.Core.Decoration.Scalar.Commands;24using NBi.Core.Decoration.Style;25using NBi.Core.Decoration.Style.Font;26using NBi.Core.Decoration.Style.Font.Commands;27using NBi.Core.Decoration.Style.Format;28using NBi.Core.Decoration.Style.Format.Commands;29using NBi.Core.Decoration.Style.Padding;30using NBi.Core.Decoration.Style.Padding.Commands;31using NBi.Core.Decoration.Style.VerticalAlignment;32using NBi.Core.Decoration.Style.VerticalAlignment.Commands;33using NBi.Core.Injection;34using NBi.Core.Injection.Command;35using NBi.Core.Injection.Command.Converter;36using NBi.Core.Injection.Command.DbCommand;37using NBi.Core.Injection.Command.File;38using NBi.Core.Injection.Command.Process;39using NBi.Core.Injection.Command.Text;40using NBi.Core.Injection.Command.Xml;41using NBi.Core.Injection.Service;42using NBi.Core.Injection.Service.Converter;43using NBi.Core.Injection.Service.DbCommand;44using NBi.Core.Injection.Service.File;45using NBi.Core.Injection.Service.Process;46using NBi.Core.Injection.Service.Text;47using NBi.Core.Injection.Service.Xml;48using NBi.Core.Query;49using NBi.Core.Query.Execution;50using NBi.Core.Query.Resolver;51using NBi.Core.Report;52using NBi.Core.Report.FailureReport;53using NBi.Core.Report.FailureReport.Html;54using NBi.Core.ResultSet;55using NBi.Core.ResultSet.Alteration.Duplication;56using NBi.Core.ResultSet.Alteration.Duplication.Strategy;57using NBi.Core.ResultSet.Alteration.Extension;58using NBi.Core.ResultSet.Alteration.Extension.Strategy;

GetConnectionString

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.OfficeDataConnectionFileParser;7using NBi.Core;8{9    {10        static void Main(string[] args)11        {12            var connectionString = new NBi.Core.OfficeDataConnectionFileParser().GetConnectionString(@"C:\Users\test.xlsx");13            Console.WriteLine(connectionString);14            Console.ReadLine();15        }16    }17}

GetConnectionString

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core;7using System.Data.OleDb;8{9    {10        static void Main(string[] args)11        {12            string connectionString = OfficeDataConnectionFileParser.GetConnectionString(@"C:\Users\Public\Documents\Northwind.accdb");13            using (OleDbConnection conn = new OleDbConnection(connectionString))14            {15                conn.Open();16            }17        }18    }19}20using System;21using System.Collections.Generic;22using System.Linq;23using System.Text;24using System.Threading.Tasks;25using NBi.Core;26using System.Data.OleDb;27{28    {29        static void Main(string[] args)30        {31            string connectionString = ExcelDataConnectionFileParser.GetConnectionString(@"C:\Users\Public\Documents\Northwind.xlsx");32            using (OleDbConnection conn = new OleDbConnection(connectionString))33            {34                conn.Open();35            }36        }37    }38}39using System;40using System.Collections.Generic;41using System.Linq;42using System.Text;43using System.Threading.Tasks;44using NBi.Core;45using System.Data.OleDb;46{47    {48        static void Main(string[] args)49        {50            string connectionString = ExcelDataConnectionFileParser.GetConnectionString(@"C:\Users\Public\Documents\Northwind.xls");51            using (OleDbConnection conn = new OleDbConnection(connectionString))52            {53                conn.Open();54            }55        }56    }57}58using System;59using System.Collections.Generic;60using System.Linq;61using System.Text;62using System.Threading.Tasks;63using NBi.Core;64using System.Data.OleDb;65{66    {67        static void Main(string[] args)

GetConnectionString

Using AI Code Generation

1NBi.Core.OfficeDataConnectionFileParser parser = new NBi.Core.OfficeDataConnectionFileParser();2string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");3NBi.Core.Excel.ExcelDataConnectionFileParser parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();4string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");5NBi.Core.Excel.ExcelOleDbDataConnectionFileParser parser = new NBi.Core.Excel.ExcelOleDbDataConnectionFileParser();6string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");7NBi.Core.Excel.ExcelOleDbDataConnectionFileParser parser = new NBi.Core.Excel.ExcelOleDbDataConnectionFileParser();8string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");9NBi.Core.Excel.ExcelOleDbDataConnectionFileParser parser = new NBi.Core.Excel.ExcelOleDbDataConnectionFileParser();10string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");11NBi.Core.Excel.ExcelOleDbDataConnectionFileParser parser = new NBi.Core.Excel.ExcelOleDbDataConnectionFileParser();12string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");13NBi.Core.Excel.ExcelOleDbDataConnectionFileParser parser = new NBi.Core.Excel.ExcelOleDbDataConnectionFileParser();14string connectionString = parser.GetConnectionString("C:\\Users\\myuser\\Documents\\MyExcel.xlsx");

GetConnectionString

Using AI Code Generation

1var parser = new NBi.Core.OfficeDataConnectionFileParser();2var connectionString = parser.GetConnectionString("C:\\temp\\Excel.xlsx");3Console.WriteLine(connectionString);4var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();5var connectionString = parser.GetConnectionString("C:\\temp\\Excel.xlsx");6Console.WriteLine(connectionString);7var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();8var connectionString = parser.GetConnectionString("C:\\temp\\Excel.xls");9Console.WriteLine(connectionString);10var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();11var connectionString = parser.GetConnectionString("C:\\temp\\Excel.xlsb");12Console.WriteLine(connectionString);13var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();14var connectionString = parser.GetConnectionString("C:\\temp\\Excel.xlsx", "Provider=Microsoft.Jet.OLEDB.4.0");15Console.WriteLine(connectionString);

GetConnectionString

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core;7using System.IO;8{9    {10        static void Main(string[] args)11        {12            string file = @"C:\test\test.xlsx";13            string connection = OfficeDataConnectionFileParser.GetConnectionString(file);14            Console.WriteLine(connection);15            Console.ReadKey();16        }17    }18}19Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\test\test.xlsx;Extended Properties=Excel 12.0 Xml;Persist Security Info=False20public static string GetConnectionString(string file)

GetConnectionString

Using AI Code Generation

1var parser = new NBi.Core.OfficeDataConnectionFileParser();2var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");3var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();4var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");5var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();6var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");7var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();8var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");9var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();10var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");11var parser = new NBi.Core.Excel.ExcelDataConnectionFileParser();12var cs = parser.GetConnectionString("C:\\Users\\Me\\Documents\\Visual Studio 2013\\Projects\\ConsoleApplication1\\ConsoleApplication1\\bin\\Debug\\1.xlsx", "Excel 12.0");

GetConnectionString

Using AI Code Generation

1var parser = new NBi.Core.OfficeDataConnectionFileParser();2var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2007-2010.dsn");3var parser = new NBi.Core.OfficeDataConnectionFileParser();4var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2007-2010.dsnx");5var parser = new NBi.Core.OfficeDataConnectionFileParser();6var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2003.dsn");7var parser = new NBi.Core.OfficeDataConnectionFileParser();8var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2003.dsnx");9var parser = new NBi.Core.OfficeDataConnectionFileParser();10var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2007-2010.xlsx");11var parser = new NBi.Core.OfficeDataConnectionFileParser();12var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel\Excel2007-2010.xls");13var parser = new NBi.Core.OfficeDataConnectionFileParser();14var connectionString = parser.GetConnectionString(@"C:\Users\Public\Documents\NBi\NBi.Tests\NBi.Testing.Core\Excel

GetConnectionString

Using AI Code Generation

1string connection = NBi.Core.OfficeDataConnectionFileParser.GetConnectionString("C:\\Users\\sachin\\Documents\\Visual Studio 2010\\Projects\\NBi\\NBi\\TestCases\\1.xlsx");2Console.WriteLine(connection);3string connection = NBi.Core.ExcelDataConnectionFileParser.GetConnectionString("C:\\Users\\sachin\\Documents\\Visual Studio 2010\\Projects\\NBi\\NBi\\TestCases\\1.xlsx");4Console.WriteLine(connection);5Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sachin\Documents\Visual Studio 2010\Projects\NBi\NBi\TestCases\1.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";6  <connection-string>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\sachin\Documents\Visual Studio 2010\Projects\NBi\NBi\TestCases\1.xlsx;Extended Properties="Excel 12.0 Xml;HDR=YES";</connection-string>

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.