CodedThought.Core.Data.SqlServer
8.0.1.5
dotnet add package CodedThought.Core.Data.SqlServer --version 8.0.1.5
NuGet\Install-Package CodedThought.Core.Data.SqlServer -Version 8.0.1.5
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="CodedThought.Core.Data.SqlServer" Version="8.0.1.5" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="CodedThought.Core.Data.SqlServer" Version="8.0.1.5" />
<PackageReference Include="CodedThought.Core.Data.SqlServer" />
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 CodedThought.Core.Data.SqlServer --version 8.0.1.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CodedThought.Core.Data.SqlServer, 8.0.1.5"
#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.
#:package CodedThought.Core.Data.SqlServer@8.0.1.5
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=CodedThought.Core.Data.SqlServer&version=8.0.1.5
#tool nuget:?package=CodedThought.Core.Data.SqlServer&version=8.0.1.5
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
CodedThought.Core.Data.SqlServer
A .NET Core Data Entity Provider for Sql Server.
Requirements
SqlServer requires CodedThough.Core.Configuration and CodedThought.Core. These can be found in NuGet. - CodedThought.Core.Configuration - CodedThought.Core
Usage
- Install required packages. See requirements above.
- Add the Database Connection settings in the appSetting.json or a custom .json file.
Note: See CodedThought.Core.Configuration for JSON configguration specifications.
- Add a new class and inherit from
CodedThough.Core.Data.GenericDataStoreController. Below is a sample class file.
using CodedThought.Core;
using CodedThought.Core.Data;
public class DataController : GenericDataStoreController {
public DataController(IMemoryCache cache, CodedThought.Core.Configuration.ConnectionSetting connectionSetting ) {
DataStore = new GenericDataStore(cache, connectionSetting, "dbo");
}
public Person GetPerson(string email)
{
try
{
ParameterCollection param = DataStore.CreateParameterCollection();
param.AddStringParameter("EmailAddress", email);
return DataStore.Get<Person>(param);
} catch (Exception)
{
throw;
}
}
public List<Person> GetPeople() {
try {
return DataStore.GetMultiple<Person>(null);
} catch {
throw;
}
}
}
using System.Data;
using CodedThought.Core;
using CodedThought.Core.Data;
///<summary>
/// Person class used by the framework to locate the right table and columns with class and proprety annotations.
///</summary>
[DataTable("tblPeople")]
public class Person
{
public Person() { }
[DataColumn("EmailAddress", DbType.String, DataColumnOptions.PrimaryKey)]
public string EmailAddress { get; set; }
[DataColumn("FirstName", DbType.String)]
public string FirstName { get; set; }
[DataColumn("LastName", DbType.String)]
public string LastName { get; set; }
}
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | 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.
-
net8.0
- CodedThought.Core (>= 8.0.1.38)
- Microsoft.Data.SqlClient (>= 6.0.2)
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 |
|---|---|---|
| 8.0.1.5 | 237 | 6/17/2025 |
| 8.0.1.4 | 206 | 6/17/2025 |
| 8.0.1.1 | 187 | 12/11/2024 |
| 8.0.1 | 192 | 11/20/2024 |
| 8.0.0-beta-7 | 138 | 11/6/2024 |
| 8.0.0-beta-6 | 360 | 6/3/2024 |
| 8.0.0-beta-5 | 166 | 5/30/2024 |
| 8.0.0-beta-4 | 170 | 5/30/2024 |
| 8.0.0-beta-3 | 154 | 5/30/2024 |
| 8.0.0-beta-2 | 168 | 5/30/2024 |
| 8.0.0-beta-1 | 167 | 5/29/2024 |
| 8.0.0-alpha-7 | 170 | 5/17/2024 |
Loading failed
Updated to use new Add override that allows passing the schema in and will use the default schema is not passed in and is available.