DubUrl 0.18.68

dotnet add package DubUrl --version 0.18.68                
NuGet\Install-Package DubUrl -Version 0.18.68                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="DubUrl" Version="0.18.68" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add DubUrl --version 0.18.68                
#r "nuget: DubUrl, 0.18.68"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install DubUrl as a Cake Addin
#addin nuget:?package=DubUrl&version=0.18.68

// Install DubUrl as a Cake Tool
#tool nuget:?package=DubUrl&version=0.18.68                

DubUrl

DubUrl provides a standard, URL style mechanism for parsing database connection strings and opening DbConnections for .NET. With DubUrl, you can parse and open URLs for popular databases such as Microsoft SQL Server, PostgreSQL, MySQL, SQLite3, Oracle Database and most of the other SQL databases. This project is inspired from the package dburl available in the GoLang ecosystem and is trying to match the aliases for portocols.

About | Overview | Quickstart | Examples | Schemes | Installing | Using

About

Social media: website twitter badge

Releases: nuget licence badge

Dev. activity: GitHub last commit Still maintained GitHub commit activity

Continuous integration builds: Build status Tests CodeFactor codecov FOSSA Status

Status: stars badge Bugs badge Top language

Mappers for ADO.Net Provider implemented badge Mappers for ODBC drivers implemented badge Mappers for OLE DB providers implemented badge Mappers for ADOMD.NET providers implemented badge

Upcoming features badge Upcoming databases badge Upcoming ADO.Net badge Upcoming ODBC badge

Database Connection URL Overview

Supported database connection URLs are of the form:

driver:alias://user:pass@host/dbname?opt1=a&opt2=b

Where:

Component Description
alias database type (see below)
driver driver/provider name (only for odbc/oleodbc)
user username
pass password
host host
dbname<sup>*</sup> database, instance, or service name/ID to connect to
?opt1=... additional database driver options (see respective SQL driver for available options)

<i><sup><b>*</b></sup> for Microsoft SQL Server, /dbname can be /instance/dbname, where /instance is optional. For Oracle Database, /dbname is of the form /service/dbname where /service is the service name or SID, and /dbname is optional. Please see below for examples.</i>

Quickstart

Database connection URLs in the above format can be parsed to a standard connection string with the [Parse] as such:

string connectionUrl = "mssql://{server}/{database_name}";
string connectionString = new ConnectionUrl(connectionUrl).Parse();

Additionally, a simple helper, [Open], is provided that will parse, open, and return a standard DbConnection.

string connectionUrl = "mssql://{server}/{database_name}";
IDbConnection connection = new ConnectionUrl(connectionUrl).Open();

If you don't want to open the connection but only return it and manage its state by yourself, use the function [Connect]

string connectionUrl = "mssql://{server}/{database_name}";
IDbConnection connection = new ConnectionUrl(connectionUrl).Connect();

Example URLs

The following are example database connection URLs that can be handled by [Parse], [Connect] and [Open]:

mssql://user:pass@remote-host.com/instance/dbname?keepAlive=10
oledb+mssql://user:pass@localhost/dbname

postgres://user:pass@localhost/dbname
odbc+postgres://user:pass@localhost:port/dbname?option1=

mysql://user:pass@localhost/dbname
oracle://user:pass@somehost.com/sid
db2://user:pass@localhost/dbname

Protocol Schemes and Aliases

ADO.Net data providers

The following databases and their associated schemes are supported out of the box:

Database Aliases Provider Invariant Name
Microsoft SQL Server mssql, ms, sqlserver, mssqlserver Microsoft.Data.SqlClient
MySQL mysql, my MySqlConnector
PostgreSQL pg, pgx, pgsql, postgres, postgresql Npgsql
Oracle Database oracle, or, ora Oracle.ManagedDataAccess
IBM DB2 db2 IBM.Data.Db2
MariaDB maria, mariadb MySqlConnector
DuckDB duck, duckdb DuckDB.NET.Data
Firebird SQL fb, firebird FirebirdSql.Data.FirebirdClient
SQLite3 sq, sqlite Microsoft.Data.Sqlite
Teradata td, teradata, tera Teradata.Client
Snowflake sf, snowflake Snowflake.Data
CockRoachDB cr, cockroach, cockroachdb, crdb, cdb Npgsql
CrateDB crt, crate, cratedb Npgsql
SingleStore sg, sgs, singlestore, single SingleStoreConnector
Trino tr, trino NReco.PrestoAdo
QuestDb quest, questdb Npgsql
Timescale ts, timescale Npgsql

ODBC driver locators

The following databases and their associated schemes are supported out of the box:

Database Aliases Name Pattern
Microsoft SQL Server mssql, ms, sqlserver, mssqlserver ^\bODBC Driver\s([0-9]{1,2}(?:.[0-9]{1,2}){0,2})\s\bfor SQL Server$
MySQL mysql, my ^\bMySQL ODBC\s([0-9]{1,2}(?:.[0-9]{1,2}){0,2})\s(ANSI|Unicode)\s\bDriver$
PostgreSQL pg, pgx, pgsql, postgres, postgresql ^\bPostgreSQL\s(ANSI|Unicode)((x64))?$
MariaDB maria, mariadb ^\bMariaDB ODBC\s([0-9]{1,2}(?:.[0-9]{1,2}){0,2})\s\bDriver$
DuckDB duck, duckdb ^\bDuckDB\s\bDriver$
Apache Drill drill ^\bMapR Drill ODBC Driver$
Trino tr, trino ^(Simba)\s\bTrino ODBC Driver$
Microsoft Access accdb, access, msaccess, mdb ^\bMicrosoft Access Driver\s(*.mdb, *.accdb)$
Microsoft Excel xls, xlsx, xlsb, xlsm ^\bMicrosoft Excel Driver\s(*.xls, *.xlsx, *.xlsm, *.xlsb)$
Text files txt, csv, tsv ^\bMicrosoft Access Text Driver\s(*.txt, *.csv)$
QuestDb quest, questdb ^\bPostgreSQL\s(ANSI|Unicode)((x64))?$
Timescale ts, timescale ^\bPostgreSQL\s(ANSI|Unicode)((x64))?$

Extension for OLEDB provider locators

The following databases and their associated schemes are supported through the OLE DB data provider extension:

Database Aliases Name Pattern
Microsoft SQL Server mssql, ms, sqlserver, mssqlserver ^\bMSOLEDBSQL$
MySQL mysql, my ^\bMySQL Provider$
Microsoft Excel xls ^\bMicrosoft.ACE.OLEDB.([0-9]{1,2}(?:.[0-9]{1,2}){0,2})$
Microsoft Excel xlsx ^\bMicrosoft.ACE.OLEDB.([0-9]{1,2}(?:.[0-9]{1,2}){0,2})$
Microsoft Excel xlsm ^\bMicrosoft.ACE.OLEDB.([0-9]{1,2}(?:.[0-9]{1,2}){0,2})$
Microsoft Excel xlsb ^\bMicrosoft.ACE.OLEDB.([0-9]{1,2}(?:.[0-9]{1,2}){0,2})$
Microsoft Access accdb, access, msaccess, mdb ^\bMicrosoft.ACE.OLEDB.([0-9]{1,2}(?:.[0-9]{1,2}){0,2})$

Extension for ADOMD.NET data provider

The following databases and their associated schemes are supported through the ADOMD.NET data provider extension:

Database Aliases Provider Invariant Name
Azure Analysis Services asazure, asa Microsoft.AnalysisServices.AdomdClient
Power BI Desktop pbidesktop, pbix, powerbidesktop Microsoft.AnalysisServices.AdomdClient
Power BI Premium powerbi, pbi, pbiazure, pbipremium, powerbipremium Microsoft.AnalysisServices.AdomdClient
SQL Server Analysis Services - Multidimensional ssasmultidim, ssasmdx Microsoft.AnalysisServices.AdomdClient
SQL Server Analysis Services - Tabular ssastabular, ssasdax Microsoft.AnalysisServices.AdomdClient

Installing

Install in the usual .NET fashion:

Install-Package DubUrl

To install the extension for OLEDB provider locators

Install-Package DubUrl.OleDb

To install the extension for ADOMD.NET data provider

Install-Package DubUrl.Adomd

Using

Check the first steps guide on the website.

Please note that DubUrl does not install actual drivers, and only provides a standard way to [Parse] respective database connection URLs then [Connect] or [Open] connections.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (5)

Showing the top 5 NuGet packages that depend on DubUrl:

Package Downloads
DubUrl.OleDb

DubUrl provides a standardized URL-style mechanism for providing database connection information and opening a DbConnection in the .NET ecosystem

DubUrl.Extensions.DependencyInjection

DubUrl provides a standardized URL-style mechanism for providing database connection information and opening a DbConnection in the .NET ecosystem

DubUrl.Adomd

DubUrl provides a standardized URL-style mechanism for providing database connection information and opening a DbConnection in the .NET ecosystem

DubUrl.Extensions

DubUrl provides a standardized URL-style mechanism for providing database connection information and opening a DbConnection in the .NET ecosystem

Tseesecake

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
0.18.68 121 9/30/2024
0.18.67 150 9/16/2024
0.18.66 134 9/15/2024
0.18.65 130 9/15/2024
0.18.64 149 9/14/2024
0.18.62 150 9/9/2024
0.18.61 148 9/9/2024
0.18.60 142 9/2/2024
0.18.59 139 9/2/2024
0.18.58 134 9/3/2024
0.18.57 150 8/26/2024
0.18.56 160 8/21/2024
0.18.55 168 8/18/2024
0.18.54 160 8/15/2024
0.18.53 154 8/11/2024
0.18.51 96 7/29/2024
0.18.50 136 7/17/2024
0.18.49 127 7/17/2024
0.18.47 131 7/17/2024
0.18.45 127 7/14/2024
0.18.44 139 7/7/2024
0.18.43 142 7/7/2024
0.18.42 130 7/6/2024
0.18.41 141 7/6/2024
0.18.39 137 7/6/2024
0.18.38 155 7/6/2024
0.18.37 139 6/25/2024
0.18.36 153 6/23/2024
0.18.33 158 5/20/2024
0.18.32 148 5/20/2024
0.18.31 152 5/19/2024
0.18.30 167 5/15/2024
0.18.29 156 5/15/2024
0.18.28 164 5/15/2024
0.18.27 145 5/14/2024
0.18.24 139 5/14/2024
0.18.22 179 4/15/2024
0.18.20 161 4/15/2024
0.18.19 164 4/1/2024
0.18.18 212 3/25/2024
0.18.17 227 3/23/2024
0.18.16 223 3/23/2024
0.18.15 211 3/23/2024
0.18.14 203 3/23/2024
0.18.13 209 3/23/2024
0.18.12 251 3/11/2024
0.18.11 263 3/10/2024
0.18.10 267 3/10/2024
0.18.9 278 2/28/2024
0.18.8 289 2/17/2024
0.18.6 301 2/17/2024
0.18.5 278 2/17/2024
0.18.4 296 2/17/2024
0.18.3 289 2/17/2024
0.18.2 304 2/17/2024
0.18.0 325 2/11/2024
0.17.6 331 2/9/2024
0.17.5 318 2/9/2024
0.17.4 320 2/7/2024
0.17.3 321 2/7/2024
0.17.2 292 2/7/2024
0.17.1 311 1/30/2024
0.17.0 290 1/28/2024
0.16.0 320 1/27/2024
0.15.0 303 1/27/2024
0.14.0 316 1/27/2024
0.13.1 342 1/27/2024
0.13.0 336 1/22/2024
0.12.1 343 1/22/2024
0.12.0 318 1/22/2024
0.11.0 335 1/20/2024
0.10.0 331 1/20/2024
0.9.11 314 1/20/2024
0.9.10 304 1/20/2024
0.9.9 324 1/19/2024
0.9.8 323 1/19/2024
0.9.7 335 1/19/2024
0.9.6 307 1/19/2024
0.9.5 317 1/18/2024
0.9.2 425 1/8/2024
0.9.1 370 1/5/2024
0.9.0 374 12/30/2023
0.8.7 386 12/30/2023
0.8.6 407 12/25/2023
0.8.5 388 12/21/2023
0.8.4 386 12/21/2023
0.8.3 434 12/11/2023
0.8.2 425 12/11/2023
0.8.1 429 12/11/2023
0.8.0 422 12/9/2023
0.7.3 407 12/6/2023
0.7.2 456 12/5/2023
0.7.1 453 11/28/2023
0.7.0 416 11/27/2023
0.6.0 437 11/26/2023
0.5.11 445 11/25/2023
0.5.9 419 11/25/2023
0.5.8 431 11/25/2023
0.5.6 439 11/25/2023
0.5.5 414 11/25/2023
0.5.1 426 11/25/2023
0.5.0 457 11/18/2023
0.4.14 405 11/16/2023
0.4.6 428 11/16/2023
0.4.5 446 11/13/2023
0.4.4 403 11/13/2023
0.4.3 438 11/12/2023
0.4.2 409 11/12/2023
0.4.1 430 11/7/2023
0.4.0 400 11/6/2023
0.3.3 434 11/6/2023
0.3.2 431 11/6/2023
0.3.1 437 11/6/2023
0.3.0 468 10/30/2023
0.2.13 444 10/30/2023
0.2.12 418 10/30/2023
0.2.11 410 10/30/2023
0.2.10 419 10/23/2023
0.2.9 454 10/23/2023
0.2.8 463 10/16/2023
0.2.7 465 10/16/2023
0.2.6 460 10/9/2023
0.2.5 427 10/9/2023
0.2.4 431 10/9/2023
0.2.3 463 10/2/2023
0.2.0 552 9/30/2023
0.1.233 622 9/21/2023
0.1.231 536 9/19/2023
0.1.230 494 9/18/2023
0.1.228 471 9/18/2023
0.1.227 554 9/15/2023
0.1.226 498 9/14/2023
0.1.225 497 9/12/2023
0.1.224 499 9/10/2023
0.1.223 504 9/10/2023
0.1.222 493 9/9/2023
0.1.219 526 9/8/2023
0.1.218 518 9/7/2023
0.1.217 526 9/6/2023
0.1.216 557 8/28/2023
0.1.215 517 8/28/2023
0.1.214 529 8/23/2023
0.1.213 523 8/23/2023
0.1.212 577 8/15/2023
0.1.211 559 8/14/2023
0.1.210 548 8/12/2023
0.1.209 607 8/8/2023
0.1.208 696 8/1/2023
0.1.207 730 7/31/2023
0.1.206 630 7/31/2023
0.1.205 602 7/31/2023
0.1.204 629 7/30/2023
0.1.203 595 7/30/2023
0.1.202 616 7/30/2023
0.1.201 613 7/29/2023
0.1.200 635 7/11/2023
0.1.199 684 7/3/2023
0.1.198 641 7/1/2023
0.1.197 681 6/30/2023
0.1.196 939 6/29/2023
0.1.195 683 6/26/2023
0.1.194 847 6/23/2023
0.1.193 629 6/23/2023
0.1.192 674 6/21/2023
0.1.191 651 6/19/2023
0.1.190 615 6/18/2023
0.1.188 647 6/18/2023
0.1.187 635 6/17/2023
0.1.186 682 6/16/2023
0.1.184 644 6/11/2023
0.1.183 669 6/8/2023
0.1.182 667 5/31/2023
0.1.180 642 5/30/2023
0.1.179 604 5/30/2023
0.1.178 623 5/29/2023
0.1.177 656 5/28/2023
0.1.176 664 5/27/2023
0.1.175 667 5/23/2023
0.1.174 659 5/22/2023
0.1.173 643 5/21/2023
0.1.172 672 5/20/2023
0.1.171 635 5/20/2023
0.1.170 637 5/15/2023
0.1.169 678 5/14/2023
0.1.168 679 5/13/2023
0.1.167 729 5/11/2023
0.1.166 672 5/11/2023
0.1.165 655 5/3/2023
0.1.164 696 4/27/2023
0.1.163 708 4/22/2023
0.1.162 713 4/18/2023
0.1.161 700 4/17/2023
0.1.160 702 4/17/2023
0.1.159 723 4/17/2023
0.1.158 731 4/17/2023
0.1.157 695 4/13/2023
0.1.156 723 4/10/2023
0.1.155 687 4/10/2023
0.1.154 727 4/10/2023
0.1.153 687 4/10/2023
0.1.152 691 4/4/2023
0.1.151 705 4/3/2023
0.1.150 794 3/28/2023
0.1.149 760 3/20/2023
0.1.148 749 3/14/2023
0.1.147 772 3/6/2023
0.1.146 763 3/5/2023
0.1.145 831 3/5/2023
0.1.144 834 3/1/2023
0.1.143 848 1/31/2023
0.1.142 845 1/31/2023
0.1.141 838 1/25/2023
0.1.140 851 1/23/2023
0.1.139 839 1/20/2023
0.1.138 896 1/3/2023
0.1.136 869 1/3/2023
0.1.133 901 12/26/2022
0.1.132 917 12/20/2022
0.1.131 890 12/20/2022
0.1.130 916 12/14/2022
0.1.129 910 11/28/2022
0.1.128 928 11/20/2022
0.1.127 958 11/20/2022
0.1.126 941 11/20/2022
0.1.125 909 11/19/2022
0.1.124 917 11/19/2022
0.1.123 948 11/19/2022
0.1.122 988 11/19/2022
0.1.121 976 11/19/2022
0.1.120 917 11/17/2022
0.1.119 932 11/17/2022
0.1.118 949 11/17/2022
0.1.115 940 11/9/2022
0.1.114 953 11/7/2022
0.1.113 913 11/2/2022
0.1.112 968 11/2/2022
0.1.111 955 11/2/2022
0.1.110 1,012 11/1/2022
0.1.109 1,002 11/1/2022
0.1.108 1,034 10/28/2022
0.1.107 1,040 10/28/2022
0.1.106 994 10/28/2022
0.1.103 1,047 10/22/2022
0.1.101 1,082 10/17/2022
0.1.100 1,089 10/17/2022
0.1.99 1,043 10/17/2022
0.1.98 1,019 10/17/2022
0.1.97 1,082 10/13/2022
0.1.96 1,076 10/3/2022
0.1.94 1,091 9/26/2022
0.1.93 1,123 9/26/2022
0.1.92 1,075 9/26/2022
0.1.91 1,083 9/24/2022
0.1.90 1,115 9/24/2022
0.1.89 1,056 9/24/2022
0.1.88 1,039 9/21/2022
0.1.87 1,102 9/20/2022
0.1.86 1,143 9/20/2022
0.1.84 1,097 9/15/2022
0.1.83 1,106 9/15/2022
0.1.82 1,097 9/11/2022
0.1.81 1,123 9/10/2022
0.1.80 1,113 9/10/2022
0.1.79 1,121 9/10/2022
0.1.78 1,109 9/10/2022
0.1.77 1,014 9/7/2022
0.1.76 934 9/7/2022
0.1.75 999 8/30/2022
0.1.74 976 8/29/2022
0.1.72 979 8/27/2022
0.1.71 805 8/27/2022
0.1.70 843 8/21/2022
0.1.69 777 8/15/2022
0.1.68 875 8/15/2022
0.1.67 829 8/15/2022
0.1.66 857 8/15/2022
0.1.65 828 8/15/2022
0.1.63 793 8/14/2022
0.1.62 808 8/14/2022
0.1.61 756 8/13/2022
0.1.60 853 8/13/2022
0.1.59 857 8/12/2022
0.1.57 787 8/12/2022
0.1.52 829 8/12/2022
0.1.50 809 8/11/2022
0.1.49 867 8/8/2022
0.1.48 832 8/8/2022
0.1.47 778 8/7/2022
0.1.46 842 8/6/2022
0.1.45 842 8/6/2022
0.1.44 833 8/5/2022
0.1.43 872 8/2/2022
0.1.42 836 8/2/2022
0.1.39 889 8/2/2022
0.1.38 858 7/31/2022
0.1.37 868 7/31/2022
0.1.36 869 7/31/2022
0.1.33 861 7/31/2022
0.1.32 861 7/16/2022
0.1.31 814 7/16/2022
0.1.27 887 7/16/2022
0.1.26 873 7/16/2022
0.1.25 853 7/15/2022
0.1.24 879 7/12/2022
0.1.23 824 7/12/2022
0.1.22 880 7/12/2022
0.1.21 854 7/12/2022
0.1.20 803 7/11/2022
0.1.19 896 7/11/2022
0.1.18 887 7/10/2022
0.1.17 867 7/5/2022
0.1.16 837 6/30/2022
0.1.15 835 6/30/2022
0.1.14 910 6/30/2022
0.1.14-beta.IBM-DB2.1 110 6/30/2022
0.1.13 834 6/30/2022
0.1.13-beta.teradata.1 119 6/30/2022
0.1.12 886 6/28/2022
0.1.12-beta.refactor-mapper.1 119 6/28/2022
0.1.11 870 6/28/2022
0.1.10 876 6/28/2022
0.1.10-beta.odbc.8 120 6/28/2022
0.1.10-beta.odbc.7 117 6/28/2022
0.1.10-beta.odbc.4 119 6/26/2022
0.1.9 863 6/25/2022
0.1.9-beta.parse-open-funct... 127 6/25/2022
0.1.8 883 6/18/2022
0.1.7 872 6/18/2022
0.1.7-beta.1 128 6/18/2022
0.1.6 820 6/18/2022
0.1.6-beta.2 132 6/18/2022
0.1.5 842 6/18/2022
0.1.4 911 6/18/2022
0.1.3-beta.7 133 6/18/2022
0.1.3-beta.3 116 6/18/2022
0.1.0 877 6/18/2022
0.1.0-alpha.8 105 6/18/2022
0.1.0-alpha.7 111 6/18/2022
0.1.0-alpha.4 117 6/18/2022