VarChar support (Non-Unicode support)

I'm using LightSpped 5 (5.0.2817.0), Non-unicode datatype (varchar) is supported?

Execute conditional query to varchar column, but parameter query is nvarchar. When a parameter type is different, performance issue cast occurs.

Thanks, Tatsuro Shibamura.

Can you give a more specific example of where this is occurring?

Jeremy

I use this table. UniqueKey is created unique index.

execute to this LightSpeed query.

var key = uow.FindOne<Key>(new Query(Entity.Attribute("UniqueKey") == "1234567890"));

generate sql query is follow. parameter type is nvarchar, for varchar column.

exec sp_executesql N'SELECT
  Keys.Id AS [Keys.Id],
  Keys.UniqueKey AS [Keys.UniqueKey]
FROM
  Keys
WHERE
  Keys.UniqueKey = @p0',N'@p0 nvarchar(10)',@p0=N'1234567890'

change column type nvarchar to varchar, SQL Server required upcast.

ex. Use nvarchar query plan.

ex. Use varchar query plan.

Thanks, this occurs because when we create the properties the type is inferred by the ADO.NET provider from the entity property data type being used, this case a string infers an nvarchar with SqlClient. The workaround for this would be to use a stored procedure where you can explicitly control the data type being used on the parameters, we dont draw a distinction between varchar columns and nvarchar columns in the designer, we map both of these to strings.

Jeremy