1

Closed

Entity model DateTime2

description

I Installed the CLR Types... Guess sql2008 is a requirement. Can you validate that with a virtual server?
 
/Swe.svc/?service=SOS&request=GetCapabilities
 
Renci.Ogc.Exceptions.NoApplicableCodeException: Application error. ---> System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Type datetime2 is not a defined system type.
Type datetime2 is not a defined system type.
Type datetime2 is not a defined system type.
Type datetime2 is not a defined system type.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.ExecuteReader(CommandBehavior behavior)
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)
at System.Data.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption)
at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()
at Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.GetContents() in D:\dev2008\OGCSOS\Renci.Ogc\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:line 465
at Renci.Ogc.WebService.Sos.GetCapabilitiesOperation.ProcessRequest(Object request) in D:\dev2008\OGCSOS\Renci.Ogc\Renci.Ogc.WebService\Sos\GetCapabilitiesOperation.cs:line 292
at Renci.Ogc.WebService.Swe.ProccessRequest(Message messageRequest) in D:\dev2008\OGCSOS\Renci.Ogc\Renci.Ogc.WebService\Swe.svc.cs:line 176
--- End of inner exception stack trace ---

file attachments

Closed Apr 2, 2009 at 9:43 PM by olegkap

comments

valentinedwv wrote Mar 31, 2009 at 3:17 PM

SOS.edmx that works with SqlServer 2005

wrote Mar 31, 2009 at 3:17 PM

olegkap wrote Mar 31, 2009 at 8:35 PM

Yes, Microsoft SQL Server System CLR Types is a requirement, you dont have to install SQL Server 2008 for this to work but Microsoft SQL Server System CLR Types will be enough. You can download it here : http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en

wrote Mar 31, 2009 at 8:35 PM

wrote Apr 2, 2009 at 9:43 PM

wrote Feb 13, 2013 at 8:37 PM

wrote May 15, 2013 at 4:48 AM