MapGuide bookmarks

A few MapGuide OpenSource links:

1. MapGuide OpenSource site
2. MapGuide Wiki
3. a MapGuide developer’s blog

Technorati tags: GIS, MapGuide

Linq2SQL: “NOT IN” SQL statement

Just a remind for myself. 😉

“NOT IN” SQL clause is a very common sql statement in most queries.
Is there something similar in Linq?  Of course!
Marco Russo’s blog post explain it very well.

Here as example from Marco’s blog:
SQL query

SELECT * FROM CUSTOMERS
WHERE ID NOT IN
(SELECT CUSTOMERID
FROM ORDERS
)

translated to Linq query:

var query =
from c in dc.Customers
where !(from o in dc.Orders
select o.CustomerID)
.Contains(c.CustomerID)
select c;

source: The NOT IN clause in LINQ to SQL.

Technorati tags: Linq, Linq2SQL, SQL

Display resolutions

Developing a multidevice program, UI architect must consider all different screen resolutions, from 320×240, to 800×480, up to 2560×2048 … 😉
Thanks to Wikipedia for a good summary, here. 🙂

source: display resolution

Cartografia del Friuli Venezia Giulia

Ricollegandomi ad alcuni post recenti (qui e qui) aggiungo i riferimenti per poter scaricare la cartogradia del Friuli Venezia Giulia, all’indirizzo  http://www.irdat.regione.fvg.it/Consultatore/cartografia/CartaTecnica/ .
Sono disponibili le mappe 1:5000 e le tavolette 1:25000, nei formati FNC, DXF e PDF. 😉

GPS security

Technology that depends on satellite-navigation signals is increasingly threatened by attack from widely available equipment, experts say.

While “jamming” sat-nav equipment with noise signals is on the rise, more sophisticated methods allow hackers even to program what receivers display.

At risk are not only sat-nav users, but also critical national infrastructure.

read full article here: Sat-nav systems under growing threat from ‘jammers’