The SQL view looks like this:
Code: Select all
CREATE OR REPLACE VIEW
portal.viewboston AS
SELECT
cat.idx,
cat.product,
cat.size_bytes,
cat.date,
cat.type,
cat.classification,
cat.distributor,
cat.egpl_date,
cat.classification_int,
cat.handling,
cat.creator,
cat.datum,
cat.elevation_ft,
cat.description,
cat.do_location,
cat.bbox,
cat.uniq_id::CHARACTER VARYING AS uniq_id
FROM
portal.catalog cat
WHERE
st_intersects(st_geomfromtext('POLYGON((-70 42,-71 42,-71 41,-70 41,-70 42))'::text, 4326),
cat.location);
Code: Select all
public CatalogEntry[] ViewBoston()
{
List values = new List();
GPLCatalog context = new GPLCatalog();
var query = from it in context.viewbostons
select it;
foreach (viewboston item in query)
-
Code: Select all
InnerException {"function _st_intersects(public.geometry, public.geometry) does not exist"} System.Exception {Devart.Data.PostgreSql.PgSqlException}
+ [Devart.Data.PostgreSql.PgSqlException] {"function _st_intersects(public.geometry, public.geometry) does not exist"} Devart.Data.PostgreSql.PgSqlException
+ Data {System.Collections.ListDictionaryInternal} System.Collections.IDictionary {System.Collections.ListDictionaryInternal}
HelpLink null string
+ InnerException null System.Exception
Message "function _st_intersects(public.geometry, public.geometry) does not exist" string
Source "Devart.Data.PostgreSql" string
StackTrace " at Devart.Data.PostgreSql.s.e(af A_0)\r\n at Devart.Data.PostgreSql.af.ah()\r\n at Devart.Data.PostgreSql.PgSqlCommand.InternalPrepare(Boolean implicitPrepare, Int32 startRecord, Int32 maxRecords)\r\n at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)\r\n at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)\r\n at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n at Devart.Data.PostgreSql.Entity.h.a(CommandBehavior A_0)\r\n at Devart.Common.Entity.aj.b(CommandBehavior A_0)\r\n at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)" string
+ TargetSite {Void e(Devart.Data.PostgreSql.af)} System.Reflection.MethodBase {System.Reflection.RuntimeMethodInfo}