CodedThought.Core.Data.PostGreSQL
1.0.0-alpha-1
This is a prerelease version of CodedThought.Core.Data.PostGreSQL.
There is a newer prerelease version of this package available.
See the version list below for details.
See the version list below for details.
The owner has unlisted this package.
This could mean that the package is deprecated, has security vulnerabilities or shouldn't be used anymore.
dotnet add package CodedThought.Core.Data.PostGreSQL --version 1.0.0-alpha-1
NuGet\Install-Package CodedThought.Core.Data.PostGreSQL -Version 1.0.0-alpha-1
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.PostGreSQL" Version="1.0.0-alpha-1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add CodedThought.Core.Data.PostGreSQL --version 1.0.0-alpha-1
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: CodedThought.Core.Data.PostGreSQL, 1.0.0-alpha-1"
#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.
// Install CodedThought.Core.Data.PostGreSQL as a Cake Addin
#addin nuget:?package=CodedThought.Core.Data.PostGreSQL&version=1.0.0-alpha-1&prerelease
// Install CodedThought.Core.Data.PostGreSQL as a Cake Tool
#tool nuget:?package=CodedThought.Core.Data.PostGreSQL&version=1.0.0-alpha-1&prerelease
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
CodedThought.Core.Data.PostGreSQL
A .NET Core Data Entity Provider for PostGreSQL Server.
Requirements
PostGreSQL requires Npgsql, CodedThough.Core.Configuration, and CodedThought.Core. These can be found in NuGet. - CodedThought.Core.Configuration - CodedThought.Core - Npgsql
Usage
- Install required packages. See requirements above.
- Add the Database Connection settings in the appSettings.json or a custom .json file.
Note: See CodedThought.Core.Configuration for JSON configuration 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, "public");
}
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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
net8.0
- CodedThought.Core (>= 8.0.0-alpha-7)
- Microsoft.Data.SqlClient (>= 5.2.0)
- Npgsql (>= 8.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 |
---|---|---|
1.0.0-alpha-5 | 32 | 5/31/2024 |
1.0.0-alpha-4 | 50 | 5/22/2024 |