SymbioticQuery.NetStandard_x64 1.0.1

.NET Standard 2.0
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 SymbioticQuery.NetStandard_x64 --version 1.0.1
NuGet\Install-Package SymbioticQuery.NetStandard_x64 -Version 1.0.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="SymbioticQuery.NetStandard_x64" Version="1.0.1" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add SymbioticQuery.NetStandard_x64 --version 1.0.1
#r "nuget: SymbioticQuery.NetStandard_x64, 1.0.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 SymbioticQuery.NetStandard_x64 as a Cake Addin
#addin nuget:?package=SymbioticQuery.NetStandard_x64&version=1.0.1

// Install SymbioticQuery.NetStandard_x64 as a Cake Tool
#tool nuget:?package=SymbioticQuery.NetStandard_x64&version=1.0.1

Allows a developer to write database queries using standard .net code, the queries are written in a similar manner as sql except you reference your .net objects instead of tables, the object and properties are mapped to the schema with attributes. This provides an abstraction from the schema/database and also the queries are database agnostic. This method also provides many extra compiler checks to the query. The .net code queries build the database vendor specific sql for execution. The generated sql can easily be reviewed and tested.

Product Compatible and additional computed target framework versions.
.NET net5.0 was computed.  net5.0-windows was computed.  net6.0 was computed.  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 was computed.  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. 
.NET Core netcoreapp2.0 was computed.  netcoreapp2.1 was computed.  netcoreapp2.2 was computed.  netcoreapp3.0 was computed.  netcoreapp3.1 was computed. 
.NET Standard netstandard2.0 is compatible.  netstandard2.1 was computed. 
.NET Framework net461 was computed.  net462 was computed.  net463 was computed.  net47 was computed.  net471 was computed.  net472 was computed.  net48 was computed.  net481 was computed. 
MonoAndroid monoandroid was computed. 
MonoMac monomac was computed. 
MonoTouch monotouch was computed. 
Tizen tizen40 was computed.  tizen60 was computed. 
Xamarin.iOS xamarinios was computed. 
Xamarin.Mac xamarinmac was computed. 
Xamarin.TVOS xamarintvos was computed. 
Xamarin.WatchOS xamarinwatchos 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

' ********************************************************
' ******  Copyright © 2017 Frozen Elephant Inc.     ******
' ********************************************************

--------------------------------------------------------------------------------------------
**** Symbiotic Query Revision Notes ****
--------------------------------------------------------------------------------------------


--------------------------------------------------------------------------------------------
Release version 1.0
--------------------------------------------------------------------------------------------

27-Oct-2016

I began the Symbiotic Query project.
The goal of this project will be to write queries in code for the use against a relational database and possibly against object collections.
One of the benefits is that the query is written with association to the object/s and it's properties,
whereas with the sql queries are written with the association of tables and it's columns.
With Symbiotic Query, after the mapping attributes are added, you don't have to think about the schema or the columns, just the objects.
Also if the developer using the Symbiotic Query api properly, many parts of the query is compiler checked, so if you change an objects name or property the compiler will show an error.

Currently it's partially coupled with Symbiotic ORM, and is currently being built as a replacement for embedded sql in code,
but I would like it to work seamlessly with the Symbiotic ORM.
In the long term it may become to two separate libraries but for now the goal is one library.

The goal of this library is not to fully support Structured Query Language, but most of the basic features.

5-Jan-2017
Working on table alias support, which carries over to joins and where's also.

12-Jan-2017
Working on allowing additional select column/s.

14-Jan-2017
Working on allowing additional select column/s.
Working on Selections and Case support.
Working on Group By support.

21-Jan-2017
Added support for "not in" and "not between"
Some code clean-up and removed some unneeded interfaces.

23-Jan-2017
Fixed a few bugs in the select, group by select columns.
Adding support for "Having".

24-Jan-2017
Finished support for "Having"

25-Jan-2017
Refactoring the code, moving query/sql building code to separate classes.


27-Jan-2017
Added comments to queries (sql labels) and parameters (values) to aid in trouble shooting.

28-Jan-2017
Working on support for sub selects.

29-Jan-2017
Sub selects for columns and for in() is working.
Added support to call function in a select as columns.

30-Jan-2017
More refactoring of select classes
Refactoring to better support unit testing of query builder.

31-Jan-2017
Adding tracking of types used in queries. Will be used for error handling.
Would like to reduce the method signature exposure, considering removing some methods for where’s.

24-25-Feb-2017
Finishing up refactoring of api.
Adding support for Top/Limit

26-28-Feb-2017
Adding debugger display attributes to all the query object to aid in debugging.

22-Mar-2017
Fixed the auto group by.
Added more unit tests for the query builders.

23-Mar-2017
Reworked the order by, it now allows you to specify a sort direction on the order by.
Fixed support for "Is Null" and "Is Not Null".

24-Mar-2017
Added c# unit tests project
Preparing for first release to Nuget.

26-Mar-2017
Add checks for Equal compares on null/nothing, throws an exception which will force developers to use IsNull or IsNotNull.


--------------------------------------------------------------------------------------------

28-Mar-2017
Debating if it would be useful if there was a simple way to update parameter values?

11-Sept-2017
Rework to use .Net Standard
Deployed to Nuget.org

12-Sept-2017
Added example projects.
Deployed to Nuget.org