Edit

Share via


SQL Data Developer

Use Microsoft's SQL data platform to create data-centric solutions across mobile devices and desktops for web servers, enterprise servers, and the cloud.

SQL Data storage

SQL Data tools

  • mssql extension for Visual Studio Code: Use the mssql extension in VS Code on Windows, macOS, and Linux to manage SQL Server, Azure SQL Database, SQL database in Fabric.
  • SQL Server Data Tools: Use SSDT inside Visual Studio to build relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.
  • SQL Server Management Tools: Use SSMS on Windows to configure, monitor, and administer instances of SQL Server.

SQL Data access

  • SQL Client Drivers: Use SQL drivers to connect, query, update, insert, or delete data from a SQL database.
  • Entity Framework: Use the Entity Framework to easily access databases using LINQ, with direct access to SQL Server and the option to control the mapping between an Entity Data Model (EDM) and raw relational structures.
  • Windows Communication Foundation (WCF): Use Data Services for a near-turnkey solution to easily create and consume OData services on both the web and intranet
  • Sync Framework: Use the Sync Framework to enable offline access to any data type, any data store, any transfer protocol, and any network topology.
  • Reactive Extensions: Use the Reactive Extensions (Rx) to perform event stream programming and simplify asynchronous programming using observable sequences and LINQ-style query operators. Use the Reactive Extensions for JavaScript (RxJS) to simplify asynchronous callback-based and event-driven programming on the web using observable sequences.
  • CLR Integration: Use CLR Integration to write stored procedures, triggers, user-defined types, user-defined functions, user-defined aggregates, and streaming table-valued functions, using any .NET Framework language, including Microsoft Visual Basic .NET and Microsoft Visual C#.
  • SQLXML 4.0: Use SQLXML 4.0 to export relational data to XML.

Data collection, processing, and visualization