This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Am getting the following error when deploying to a client machine. My Context is using a SqlServer2012 data provider. Do I need to deploy this SQL Server assembly with my app? Am using Lightspeed version 5.0.2302 Exception Message: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Stacktrace: System.Reflection.RuntimeAssembly._nLoad(fileName As AssemblyName, codeBase As String, assemblySecurity As Evidence, locationHint As RuntimeAssembly, stackMark As StackCrawlMark&, pPrivHostBinder As IntPtr, throwOnFileNotFound As Boolean, forIntrospection As Boolean, suppressSecurityChecks As Boolean) System.Reflection.RuntimeAssembly.nLoad(fileName As AssemblyName, codeBase As String, assemblySecurity As Evidence, locationHint As RuntimeAssembly, stackMark As StackCrawlMark&, pPrivHostBinder As IntPtr, throwOnFileNotFound As Boolean, forIntrospection As Boolean, suppressSecurityChecks As Boolean) System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(assemblyRef As AssemblyName, assemblySecurity As Evidence, reqAssembly As RuntimeAssembly, stackMark As StackCrawlMark&, pPrivHostBinder As IntPtr, throwOnFileNotFound As Boolean, forIntrospection As Boolean, suppressSecurityChecks As Boolean) System.Reflection.Assembly.Load(assemblyRef As AssemblyName) System.Data.SqlClient.SqlConnection.ResolveTypeAssembly(asmRef As AssemblyName, throwOnError As Boolean) System.Data.SqlClient.<>cDisplayClassc. System.TypeNameParser.ResolveAssembly(asmName As String, assemblyResolver As Func`2, throwOnError As Boolean, stackMark As StackCrawlMark&) System.TypeNameParser.ConstructType(assemblyResolver As Func System.TypeNameParser.GetType(typeName As String, assemblyResolver As Func System.Type.GetType(typeName As String, assemblyResolver As Func System.Data.SqlClient.SqlConnection.CheckGetExtendedUDTInfo(metaData As SqlMetaDataPriv, fThrow As Boolean) System.Data.SqlClient.SqlDataReader.GetValueFromSqlBufferInternal(data As SqlBuffer, metaData As _SqlMetaData) System.Data.SqlClient.SqlDataReader.GetValues(values As Object[]) Mindscape.LightSpeed.Mapping.EntityLoader.Read() ..( As AliasedTypeModel, As QueryExpression, As Order, As Group, As String, As Boolean, As Boolean) ..( As LightSpeedContext, As List`1, As QueryExpression, As Order, As Group, As String, As Boolean, As Boolean) ..( As AliasedTypeModel, As IList, As String, As Boolean) ..( As TypeModel, As ProcedureQuery, As IList) ..( As ProcedureQuery, As IList) Mindscape.LightSpeed.UnitOfWork.Find(query As ProcedureQuery) AMS.Management.Data.DataModel.LandDataModelUnitOfWork.SitesList(branchId As Int32) AMS.Management.Data.DataModel.Site.LoadAllFull(BranchID As Int32) AMS.Management.Land.vmSiteList.Load() |
|
|
|
|
Yes you will need to deploy this with your app if you are using the Sql2008/2012 providers to ensure it is available.
|
|
|
|
|
So I guess it raises the question of what advantages the Sql2008/2012 providers give us over say the Sql2005 provider? Why should I use them? |
|
|
|
|
You will want to use these if you are using the spatial types, custom UDT's or if you are wanting to use the newer datetime data types. The SQL 2012 provider also adds support for using the new sequence support as an identity method and uses LIMIT/OFFSET instead of ROW_NUMBER for simpler paging queries. If you are not needing any of those concerns then using the Sql2005 provider is fine.
|
|
|
|
