servicestack sql server keyword not supported ormlite

user_3581466 0
Viewed 105

I'm using servicestack in an api c# project and have referenced the

  • servicestack.ormlite
  • servicestack.ormlite.sqlserver

nuget packages.

I can connect to sql server as expected.

We are now trying to implement Always Encrypted colums in some of our sql server table columns. We append the following to our db connection strings:

";Column Encryption Setting=Enabled"

When running this line is c#:

var id = await Db.InsertAsync(customer, selectIdentity: true);

an exception is now raised:

"Keyword not supported: 'column encryption setting'."

This is probably because Always Encrypted isn't supported within the Ormlite package. Is there a way of implementing something similar with ServiceStack?

ormlite-servicestack servicestack azure-sql-database
1 Answers

This isn't an OrmLite error, it's coming from the System.Data.SqlClient ADO.NET Provider.

You'd need to use the ServiceStack.OrmLite.SqlServer.Data package which does reference the Microsoft.Data.SqlClient pacakge as suggested by the .NET Core reported Issue.

enter image description here

Which the decompiled sources shows us does reference the Microsoft.Data.SqlClient namespace:

enter image description here

If that doesn't work, see if you can open a connection directly with the Microsoft.Data.SqlClient SqlConnection class, e.g:

var conn = new SqlConnection(connectionString);
conn.Open();
user_857850
Related