none
Does [.NET Framework Data Provider for SQL Server] use SQL Server Native Client? RRS feed

  • Question

  • SQL Server Native Client supports the "Application Intent" setting in the connection string. Does [.NET Framework Data Provider for SQL Server] support this setting in the connection string

    Thursday, December 14, 2017 5:26 PM

All replies

  • Hi Jay Atta,

    Thank you for posting here.

    For your question, if you're using a managed programming language such as Microsoft Visual C# or Visual Basic, and you need to access the new features in SQL Server, you should use the .NET Framework Data Provider for SQL Server, which is part of the .NET Framework.

    If you are developing a COM-based application and need to access the new features introduced in SQL Server, you should use SQL Server Native Client. If you don't need access to the new features of SQL Server, you can continue to use Windows Data Access Components (WDAC).

    For more details, please refer to the MSDN article.

    https://docs.microsoft.com/en-us/sql/relational-databases/native-client/when-to-use-sql-server-native-client

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Monday, December 18, 2017 12:48 AM
    Moderator