What Type System Version (Compatibility Level) token can I specify in ADO.NET connection string to indicate that only SQL Server 2012 is supported?
What is the Type System Version (Compatibility Level) for SQL Server 2012
2.1k views Asked by abatishchev At
1
There are 1 answers
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in ADO.NET
- Passing parameters in C# to SQL Server stored procedure - too many arguments specified
- How to increase data reading performance of returned cursor value ADO.NET with Oracle Reader
- Why is calling T-SQL INSERT with SELECT @@IDENTITY inserting duplicates?
- c# - Managing transactions
- Unable to cast object of type 'System.DBNull' to type 'System.Int32' exception in ADO.NET
- DataGridView binded to a DataSet doesn't get updated from another form
- The fastest way to UPDATE multiple rows in C# ADO .NET
- How not to load navigation properties in datagridview using Entity Framework?
- Merge query to upsert data is always inserting the data when run from .NET 6 Web API
- Get all users of an Ado or TFS project
- Call a postgres SP using ADO.NET with parameter as Custom Type
- Calling AJAX methods in parallel increases server response time?
- Issue in Connecting to SQL Server 2008 R2 from .Net application on a different Server
- How to use variable from behind codes on a server tag attribute in listview in ASP.NET using C#
- Operand type clash: int is incompatible with date in sql
Related Questions in CONNECTION-STRING
- vb.net connection string to a regular google drive
- How can I run my C# app using a SQLConnection to SQL Server with Windows Authentication in a PC not joined to domain?
- Using multiple connection strings in blazor 8.0
- Azure App Service Connection String Not Working
- Protect appsettings.json in net core
- Fetching json data from MongoDB returns an empty array instead of actual data
- Visual Studio Debug SQL Server Connection String - "SSL Provider, error 0 - The certificate chain was issued by an authority that is not trusted"
- How to use a unified connection string to Docker container SQL Server from both local host and another container?
- Powershell and SQL Connection String Error
- How to establish a connection with SAP ABAP workbench with SSIS
- Azure CI/CD Deployment: Challenges with Database Schema Updates and Connection String Management
- API Testing / DB Connections in Angular17
- Unable to connect to mongoDB using connection String in apache camel
- Multiple Active Result Sets vs MultipleActiveResultSets
- How to use DefaultAzureCredentialOptions with ServiceBus triggers?
Related Questions in SQL-SERVER-2012
- Able to initially retrieve string from varbinary but not able to retrieve it again after setting it from ascii file?
- ASP.NET Core web application running slow & occasionally timing out while running large queries to database after updating to .NET 8
- Connecting to API via Microsoft SQL Server 2012
- SQL Substring from a column of strings
- Sum time of consecutive rows with condition of filed
- Trying to delete records from a table that has 20 million records
- CROSS JOIN and STDistance to find closest point
- Getting the Penultimate Record from a Table Sorted by Descending ID
- Make 1 row result from two result using SQL Server
- How can I reliably store an ID so that I can use it in another INSERT statement?
- How can I add a whole column of data as a row?
- SQL loop invalid because no scalar variable?
- Not understanding why this .bat file is only pulling some XML info and not all
- SQL Hierarchy Fill Down
- Row Number to give same value when same partition
Related Questions in COMPATIBILITY-LEVEL
- Changing database compatibility level to 2008 and back to 2016 improves performance - how can it be?
- SQL Server 2019 :: does features apply to previous compatibility level?
- Count items of json string in SQL script (compatibility version 100, no openjson)
- Slow SQL query when upgrading to COMPATIBILITY_LEVEL 120
- STRING_AGG working on compatibility level < 140
- OPENJSON in compatibility level 100 SQL SERVER 2016
- mssql-jdbc datetime java type is converted to datetime2 in compatible SQLServer 2014 vs SQLServer2016
- SQL Server : database compatibility_level after upgrade
- Can switching compatibility level from 100 to 130 lead to locking or deadlock problems?
- Power BI merge query in SSAS Tabular 1400
- Why is this allowed: create database [MyExample] with compatibility_level = 100
- How to adjust Compatibility Level after database restore?
- How to check safety of changing SQL Server database compatibility level?
- ADO returns bad data when DB compatibility level is > 90
- How can I set compatibility level 80 in SQL Server 2012?
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
According to this it will be "SQL Server 2012". While the page is for the .NET framework 4.5 and thus still pre release, given the other possible values for the parameter, it is safe to assume that this value will stand.
Having that said, I don't know if any .NET version below 4.5 will even accept that value as valid. I'm not at a computer right now, so I cannot check, sorry.
EDIT It looks as if this value is indeed parsed/checked on the client side, i.e. inside
System.Data. Looking with Reflector, it happens inSqlConnectionString.SqlConnectionString(string connectionString). Also, there is an enumerationSqlConnectionString.TypeSystemwhich names all the known/supported values. For .NET 4.0 that would beSqlServer2000,SqlServer2005,SqlServer2008andLatest. This value is the passed around inside theSystem.Data.SqlClientclasses and ends up being used somewhere insideSqlDataReader.So, unless you use
Latestwhich would use but not force SQL Server 2012, there is no way to force SQL Server 2012 type system with .NET < 4.5.