History of Microsoft SQL Server, .NET Core Versions , C# | Version History

History of Microsoft SQL Server

  

Version

Release
Date

Mainstream
End Date

Extended
End Date

Release name

Code name

Internal
database version

1.0 (OS/2)

1989

?

?

SQL Server 1.0 (16-bit)

Filipi

 –

1.1 (OS/2)

1990

?

?

SQL Server 1.1 (16-bit)

Pietro

 –

4.2A (OS/2)

1992

?

?

SQL Server 4.2A

 –

 –

4.2B (OS/2)

1993

?

?

SQL Server 4.2B (16-bit)

 –

 –

4.21a (WinNT)

1993

?

?

SQL Server 4.21a

SQLNT

 –

6.0

1995

?

?

SQL Server 6.0

SQL95

406

6.5

1996

?

?

SQL Server 6.5

Hydra

408

7.0

1998

?

?

SQL Server 7.0

Sphinx

515

-

1999

?

?

SQL Server 7.0 OLAP Tools

Plato

 –

8.0

2000

8 April 2008

9 April 2013

SQL Server 2000

Shiloh

539

8.0

2003

?

?

SQL Server 2000 64-bit Edition

Liberty

539

9.0

14 January 2005

12 April 2011

12 April 2016

SQL Server 2005

Yukon

611/612

10.0

6 November 2008

8 July 2014

9 July 2019

SQL Server 2008

Katmai

655

10.25

2010

?

?

Azure SQL database (initial release)

Cloud database or CloudDB

 –

10.50

20 July 2010

8 July 2014

9 July 2019

SQL Server 2008 R2

Kilimanjaro (aka KJ)

661

11.0

20 May 2012

11 July 2017

12 July 2022

SQL Server 2012

Denali

706

12.0

2014

?

?

Azure SQL database

 –

 –

12.0

5 June 2014

9 July 2019

9 July 2024

SQL Server 2014

SQL14

782

13.0

1 June 2016

13 July 2021

14 July 2026

SQL Server 2016

SQL16

852

14.0

29 September 2017

11 October 2022

12 October 2027

SQL Server 2017

Helsinki

869

15.0

4 November 2019

7 January 2025

8 January 2030

SQL Server 2019

Seattle

895

 

.NET Core Versions

 

Version Number

Release Date

End of Support

Supported Visual Studio Version(s)

1.0

2016-06-27

2019-06-27

Visual Studio 20152017

1.1

2016-11-18

2019-06-27

Visual Studio 2015, 2017

2.0

2017-08-14

2018-10-01

Visual Studio 2017

2.1 long-term support

2018-05-30

2021-08-21[9]

Visual Studio 2017

2.2

2018-12-04[10]

2019-12-23[11]

Visual Studio 2017 15.9 and 2019 16.0 preview 1

3.0

2019-09-23[12]

2020-03-03[11]

Visual Studio 2017 and 2019

3.1 long-term support

2019-12-03[13]

2022-12-03[11]

Visual Studio 2019

5.0

2020-11-10[2]

Visual Studio 2019 16.8

 

  

 

 

C# | Version History

Version.NET FrameworkVisual StudioMajor Features
C# 1.0.NET Framework 1.0Visual Studio .NET 2002
C# 1.2.NET Framework 1.1Visual Studio .NET 2003
  • Basic features
C# 2.0.NET Framework 2.0Visual Studio 2005
C# 3.0.NET Framework 2.0/3.0/3.5Visual Studio 2008/2010
C# 4.0.NET Framework 4Visual Studio 2010
  • Dynamic binding
  • Named/optional arguments
  • Generic covariant and contravariant
  • Embedded interop types
C# 5.0.NET Framework 4.5Visual Studio 2012/2013
  • Asynchronous members
  • Caller info attributes
C# 6.0.NET Framework 4.6Visual Studio 2015
  • Static imports
  • Exception filters
  • Auto-property initializers
  • Expression bodied members
  • Null propagator
  • String interpolation
  • nameof operator
  • Index initializers
  • Await in catch/finally blocks
  • Default values for getter-only properties
C# 7.0.NET Framework 4.6.2Visual Studio 2017
  • Out variables
  • Tuples and deconstruction
  • Pattern matching
  • Local functions
  • Expanded expression bodied members
  • Ref locals and returns
  • Discards
  • Binary Literals and Digit Separators
  • Throw expressions
C# 7.1.NET Framework 4.7Visual Studio 2017 version 15.3
  • async Main method
  • default literal expressions
  • Inferred tuple element names
  • Pattern matching on generic type parameters
C# 7.2.NET Framework 4.7.1Visual Studio 2017 version 15.5
  • Techniques for writing safe efficient code
  • Non-trailing named arguments
  • Leading underscores in numeric literals
  • private protected access modifier
  • Conditional ref expressions
C# 7.3.NET Framework 4.7.2Visual Studio 2017 version 15.7
  • You can access fixed fields without pinning.
  • You can reassign ref local variables.
  • You can use initializers on stackalloc arrays.
  • You can use fixed statements with any type that supports a pattern.
  • You can use additional generic constraints.
C# 8.0.NET Core 3.0/.NET Standard 2.1 Visual Studio 2019 version 16.3
  • Readonly members
  • Default interface methods
  • Pattern matching enhancements
  • Switch expressions
  • Property patterns
  • Tuple patterns
  • Positional patterns
  • Using declarations
  • Static local functions
  • Disposable ref structs
  • Nullable reference types
  • Asynchronous streams
  • Indices and ranges
  • Null-coalescing assignment
  • Unmanaged constructed types
  • Stackalloc in nested expressions
  • Enhancement of interpolated verbatim strings

Next Update coming soon..... :)


No comments

Powered by Blogger.