The azure database used on CI / unit tests is not there anymore

[smoothdeveloper]

Some of the unit tests use a database hosted on azure by RedGate:

https://www.sqlservercentral.com/articles/connecting-to-adventureworks-on-azure

This seems to be offline now.

@cartermp would Microsoft contribute the same so we could still rely on it for our unit tests?

[smoothdeveloper]

#393 is affected by this

I suspected this is constructed with different values between Azure SQL and local SQL.

FSharp.Data.SqlClient/src/SqlClient.DesignTime/DesignTime.fs

Lines 549 to 555 in 8bf8672

	if scale = 0uy then
	<@@ SqlMetaData(name, dbType) @@>
	else
	<@@ SqlMetaData(name, dbType, precision, scale) @@>
	else
	let maxLength = int64 p.MaxLength
	<@@ SqlMetaData(name, dbType, maxLength) @@>

SqlMetaData.cs @ referencesource.microsoft.com

The constructors are likely to throw an exception if called "incorrectly".

https://referencesource.microsoft.com/#system.data/system/data/Sql/SqlMetaData.cs,410

       // everything except xml schema ctor
        public SqlMetaData(String name, SqlDbType dbType, long maxLength, byte precision, 
                           byte scale, long  localeId, SqlCompareOptions   compareOptions,
                           Type userDefinedType, bool useServerDefault,
                           bool isUniqueKey, SortOrder columnSortOrder, int sortOrdinal) {
            switch (dbType) {
                case SqlDbType.BigInt:
// snip
                default:
                    SQL.InvalidSqlDbTypeForConstructor(dbType);

Having an instance for development and CI purpose would help the project to address similar issues raising from discrepencies between Azure SQL and local SQL.