I am running into an issue with lightspeed 5 on the table naming. I have my tables pluralized in the database and the Model property "Plurarlized In Database" set to true. When I drag the entities in the from server explorer they are made singular but when I got to use them I get errors like the following. The only way I can see around this is to set the Table Name manually on each entity which is very inconvenient. Is there something I am missing or is this an issue with the pluralization mechanism?
Incorrect syntax near the keyword 'User'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action
1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
at ...?()
at Mindscape.LightSpeed.Profiling.Interceptor.ExecuteCommand(Func
1 baseExecutor, IUnitOfWork unitOfWork, IDbCommand command)
at ..?(IUnitOfWork , IDbCommand , Func1 )
at ..?(IUnitOfWork , IDbCommand )
at ...ctor(IUnitOfWork , IEnumerable
1 )
at Mindscape.LightSpeed.Data.DataProviderAdapter.CreateQueryExecutionStrategy(IUnitOfWork unitOfWork, IEnumerable1 sqlStatements, ProviderOptions providerOptions)
at ..?(TypeModel , Query , IList )
at ..?(UnitOfWorkBase , TypeModel , Query , IList )
at ..?(Query , TypeModel , IList )
at ..?(Query , IList )
at Mindscape.LightSpeed.UnitOfWork.Find(Query query, IList results)
at Mindscape.LightSpeed.UnitOfWorkBase.Find(Query query)
at Mindscape.LightSpeed.Linq.Plan.SingleQueryPlan.ExecuteImmediate(IUnitOfWork unitOfWork, Type returnType)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.Execute(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression)
at Mindscape.LightSpeed.Linq.LinqQuery
1.GetEnumerator()