Wednesday, September 30, 2009

.Net 3.5 Framework & LINQ

When we talk about .net 3.5 framework, LINQ is a major thing, In simple word linq is a orm.

1. LINQ to Object
Queries performed against the in-memory data
2. LINQ to ADO.Net [Example]
2.1 LINQ to SQL (formerly DLinq) {Queries performed against the relation database only Microsoft SQL Server Supported}
2.2 LINQ to DataSet {Supports queries by using ADO.NET data sets and data tables}
2.3 LINQ to Entities {Microsoft ORM solution}

3. LINQ to XML (formerly XLinq)
{ Queries performed against the XML source}

In my site i have put all examples of linq and its use.

http://etgconsultancy.com/DotNetFrameWork/Framework3p5/LINQ-Implementation.aspx

A Complete implementation of LINQ to SQL can be found here :

http://etgconsultancy.com/DotNetFrameWork/Framework3p5/Linq-to-Sql.aspx

Sunday, September 6, 2009

Implement google map, how to get coordinates

Here are the very simple steps to implement google map in your application..

I assume you have a gmail account, and you have created your mark on http://maps.google.com

So first make your google location.

Now generate your key for google map, if you dont have click on following url to generate key http://code.google.com/apis/maps/signup.html

once you get your key, replace the key in following script.

< script src="http://maps.google.com/maps?file=api&v=2&sensor=false&key=yourkey" type="text/javascript" >< / script >
< script type="text/javascript" >

function initialize() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("divMap"));
map.setCenter(new GLatLng(37.4419, -122.1419), 13);
map.setUIToDefault();
}
}

< / script >

Now place a div where you want to display the google map.

< div id="divMap" style="margin-top:12px;width:500px;height:400px;" >
< / div >

finally initialise the key

< script language="javascript" type="text/javascript" >
window.load= initialize();
< / script >


Google ma getting dipalyed on your site, but you might be wondering why your location not gettting displayed. For that you need to change the coorodinates.

How to get the coordinates ? Simply open your location in google map and copy paste the following javascript code on browser. youe get your location, replace the code in map.setCenter(new GLatLng(37.4419, -122.1419), 13); method in above script.


javascript:void(prompt('',gApplication.getMap().getCenter()));

Or

click on the right top "send" you get the following code

Hi, I'd like to share a Google Maps link with you.
Link: < http://maps.google.com/maps/ms?ie=UTF8&hl=en&msa=0&msid=103425934348104227970.000472c4205e6efea558c&ll=19.298314,72.861425&spn=0.007281,0.009624&z=17 >

Enjoy google map in your application.

Arindam
http://etgconsultancy.com