Databases
StackOverflow2013
Postsdbo
POInserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POInserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL
    primarykey
    data
    text
    <p>I installed the latest dotConnect for PostgreSQL. Im trying to insert a record in the Postgres DB. I have a geometry column what gives me errors. Here is the code:</p> <pre><code>using (var context = new WKP_DBEntities()) { var Location = DbGeometry.PointFromText(string.Format("POINT({0} {1})", 157873, 364282), 28992); var record = new monitoring_object() { geometry = Location, last_changed_by = "ssg", }; context.monitoring_object.Add(record); context.SaveChanges(); } </code></pre> <p>Here is the error message:</p> <pre><code>System.Data.Entity.Infrastructure.DbUpdateException was unhandled HResult=-2146233087 Message=An error occurred while updating the entries. See the inner exception for details. Source=EntityFramework StackTrace: at System.Data.Entity.Internal.InternalContext.SaveChanges() at System.Data.Entity.Internal.LazyInternalContext.SaveChanges() at System.Data.Entity.DbContext.SaveChanges() at ConsoleApplicationGEOdata.Program.Main(String[] args) in c:\Users\Stefan\Documents\Visual Studio 2012\Projects\ConsoleApplicationGEOdata\ConsoleApplicationGEOdata\Program.cs:line 38 at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() InnerException: System.Data.UpdateException HResult=-2146233087 Message=An error occurred while updating the entries. See the inner exception for details. Source=System.Data.Entity StackTrace: at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at System.Data.Entity.Internal.InternalContext.SaveChanges() InnerException: System.ArgumentException HResult=-2147024809 Message=Cannot convert value Source=Devart.Data.PostgreSql StackTrace: at Devart.Data.PostgreSql.af.a(Object A_0, Type A_1, Encoding A_2) at Devart.Data.PostgreSql.af.a(String A_0, Encoding A_1, PgSqlType A_2, Object A_3, Int32 A_4, Boolean A_5) at Devart.Data.PostgreSql.PgSqlCommand.a(String A_0, Encoding A_1, ArrayList A_2, Boolean A_3) at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords) at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at Devart.Data.PostgreSql.Entity.y.a(CommandBehavior A_0) at Devart.Common.Entity.i.b(CommandBehavior A_0) at Devart.Data.PostgreSql.Entity.y.b(CommandBehavior A_0) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) InnerException: </code></pre> <p>What am I doing wrong?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USStefanHa
    1. USStefanHa
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COPlease tell me you don't really mean PostgreSQL 6.7 and that you've made a typo. `SELECT version();` and paste the output into your question please. (OK, you can't possibly mean 6.7 because there was never a PostgreSQL 6.7 release; maybe you mean DotConnect 6.7 for PostgreSQL?)
      singulars
      1. POInserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL
      1. USCraig Ringer
    2. COYou seem to have cut off the most important part of the exception; that exception output is incomplete.
      singulars
      1. POInserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL
      1. USCraig Ringer
    3. COSorry it is DotConnect 6.7 for PostgreSQL. Changed it. For the exception thats all there is: I did a "Copy exception detail to the Clipboard". The last InnerException is null.
      singulars
      1. POInserting Spatial\Geometry in EF5 with dotConnect 6.7 for PostgreSQL
      1. USStefanHa
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload