Sybase NHibernate Core - ASE Native driver or DataAction

[thomasjbyrneire]

Does NHibernate Core work with Sybase (SybaseAdoNet4Driver) - I assume it doesn't because the Sybase.AdoNet4.AseClient driver does not seem to support .Net core.
I found a DataAction Ado driver (AdoNetCore.AseClient - https://github.com/DataAction/AdoNetCore.AseClient) which can connect .Net Core to Sybase 15.7.. BUT is there any way to get this driver to work with NHibernate?

[fredericDelaporte]

Check if no one has already written and publish on Nuget a NHibernate driver for this. If it is not the case, write your own.

Writing a NHibernate driver does neither require advanced knowledge, nor many lines of code. It is just a kind of helper for NHibernate to be able to instantiate adequate connections or commands classes.

In order to avoid taking hard dependencies on DB providers, most NHibernate drivers use a reflection based approach. Since there is already a base class for this for ASE, you may just derive from it and provide it the appropriate assembly and classes names, see NHibernate.Driver.SybaseAseClientDriverBase.

But in your case there is not much value in avoiding taking a hard dependency on the driver. It is instead the contrary: if you write a specific project for this driver, better take an explicit dependency on it, and then just directly implement NHibernate.Driver.DriverBase.
This mainly means overriding two methods: CreateConnection and CreateCommand, which just have to create an instance of the adequate class, without configuring them. (NHibernate will do that.) The SqlClient driver is an example of that, when targeting the .Net Framework.
Additionally you should likely override a few more properties like done in the SybaseAseClientDriverBase.

nhibernate-core/src/NHibernate/Driver/SybaseAseClientDriverBase.cs

Lines 45 to 52 in 07ecb9f

	/// <inheritdoc />
	public override string NamedPrefix => "@";
	/// <inheritdoc />
	public override bool UseNamedPrefixInParameter => true;
	/// <inheritdoc />
	public override bool UseNamedPrefixInSql => true;

Your driver may also implement IEmbeddedBatcherFactoryProvider if you want to enable batching and if there is an adequate batcher for ASE. (The NHibernate.AdoNet.GenericBatchingBatcherFactory works likely with ASE.)