SujaySarma.Data.SqlServer 9.5.0

.NET 6.0 This package targets .NET 6.0. The package is compatible with this framework or higher. 
dotnet add package SujaySarma.Data.SqlServer --version 9.5.0
                    


                    

                
NuGet\Install-Package SujaySarma.Data.SqlServer -Version 9.5.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="SujaySarma.Data.SqlServer" Version="9.5.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
<PackageVersion Include="SujaySarma.Data.SqlServer" Version="9.5.0" />
                    


                            Directory.Packages.props
                        

                    

                
<PackageReference Include="SujaySarma.Data.SqlServer" />
                    


                            Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package. 
paket add SujaySarma.Data.SqlServer --version 9.5.0
                    


                    

                
#r "nuget: SujaySarma.Data.SqlServer, 9.5.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
#addin nuget:?package=SujaySarma.Data.SqlServer&version=9.5.0
                    


                            Install as a Cake Addin
                        

                    

                
#tool nuget:?package=SujaySarma.Data.SqlServer&version=9.5.0
                    


                            Install as a Cake Tool

SujaySarma.Data.SqlServer

This is a .NET library that helps you manipulate objects and data in SQL Server databases. It supports on-prem SQL Servers, MSDE, LocalDB, named instances, SQL Azure and SQL on Linux scenarios.

API

This library provides the following public-surface API:

Attributes

Name Description
Table Map a class, structure or record to a database table.
TableColumn Map a property or field to a database table column.

In addition, this library supports creating a table for a .NET object. To support this, you would need to provide column type constraints (such as marking them as IDENTITY or providing precision/scale values). This is achieved through the following attributes:

Name Description
ColumnPrecision Specifies the precision value.
ColumnScale Specifies the scale of precision.
Identity Marks a column as an IDENTITY column and provides the SEED and INCREMENT values.

How to use

  • Decorate your classes with the TableAttribute to indicate that they represent a table in SQL Server.
  • Decorate the properties or fields in the classes with the TableColumnAttribute to indicate that they represent columns in the table. If you need to support the SDK's CreateTable functionality, add the required attributes from the second table of attributes above.
  • Use the SqlContext class to interact with SQL Server. This class provides methods for performing both DDL and DML operations on the tables, in both synchronous and asynchronous modes.

This library contains other members marked "public" that are only intended for use by a library implementing a data access mechanism. These members are part of the internal implementation and should not be used directly by consumers of the library. They are subject to change without notice and may not be available in future versions of the library. Please see the code and documentation within SujaySarma.Data.* data access implementation libraries.*

Copyright (c) 2025 and beyond, Sujay V. Sarma. All rights reserved.

Licensed under the MIT License. See LICENSE file in the project root for full license information.

Library authored and maintained by: Sujay V. Sarma.

Issues/Feedback/Suggestions/Feature requests: Please create an issue on the GitHub repository.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
9.5.0 106 6/20/2025
9.1.0 153 6/26/2024
8.9.7 145 2/15/2024
8.9.0 177 12/2/2023
8.8.5 154 11/30/2023
8.8.0 230 7/28/2023
8.7.5 202 6/27/2023
8.7.0 194 5/19/2023
8.2.0 241 3/28/2023
8.0.0 281 2/20/2023