Perceiveit.Data 1.0.0

A nuget package for the https://dynasql.codeplex.com/ project. It's a Database agnostic SQL query builder and Data Access Layer for .NET. Build safe SQL Statements using familiar syntax and execute on any database with minimal effort. Written in C# using VS 2008.

Install-Package Perceiveit.Data -Version 1.0.0
dotnet add package Perceiveit.Data --version 1.0.0
<PackageReference Include="Perceiveit.Data" Version="1.0.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Perceiveit.Data --version 1.0.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Quick SQL Sample

The following example code is all that is needed to load data from a database...

        DBDatabase db = DBDatabase.Create("Northwind");

        DBParam param1 = DBParam.ParamWithValue(1);

        DBQuery sel = DBQuery.SelectFields("CustomerID", "CustomerName")
                             .From("CUSTOMERS")
                             .WhereFieldEquals("CustomerID", param1);

        //perform all the database execution here.
        string name = null;

        db.ExecuteRead(sel, reader =>
        {
            if (reader.Read())
                name = reader.GetString(1);
        });

Quick SQL Sample

The following example code is all that is needed to load data from a database...

        DBDatabase db = DBDatabase.Create("Northwind");

        DBParam param1 = DBParam.ParamWithValue(1);

        DBQuery sel = DBQuery.SelectFields("CustomerID", "CustomerName")
                             .From("CUSTOMERS")
                             .WhereFieldEquals("CustomerID", param1);

        //perform all the database execution here.
        string name = null;

        db.ExecuteRead(sel, reader =>
        {
            if (reader.Read())
                name = reader.GetString(1);
        });

Release Notes

This particular build is built using Visual Studio 2015.

Dependencies

This package has no dependencies.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.0 701 11/27/2017