problems using sql server as database

[ardua97]

I'm trying to use sql as a database Microsoft SQL Server 2017

i created the tables on db

(i used identity instead of AUTOINCREMENT because it dont work)

i add the connection UseSqlServer

but when i start the application i have the following error SqlException: The data types text and nvarchar are incompatible in the equal to operator.

[ardua97]

i found a solution i hate to test it

i changed the datatype of the table in sql

USE [LEZ2] GO

/** Object: Table [dbo].[LocalizationRecords] Script Date: 22/10/2018 10:31:50 **/ SET ANSI_NULLS ON GO

SET QUOTED_IDENTIFIER ON GO

CREATE TABLE [dbo].[LocalizationRecords]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Key] varchar NULL, [ResourceKey] varchar NULL, [Text] varchar NULL, [LocalizationCulture] varchar NULL, [UpdatedTimestamp] [datetime] NOT NULL, CONSTRAINT [PK_DataEventRecord] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO