OData Services - CodeProject

OData Services - CodeProject:

OData URL sample

http://hldt-yanivt/YanivTZServices/AlisDataService.svc

http://hldt-yanivt/YanivTZServices/AlisDataService.svc/$metadata

//all data
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$format=json

//all id and name
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$select=country_id,country_name&$format=json

//name and id for pk=1
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries(1)?$select=country_id,country_name&$format=json

//Filter by name
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$select=country_id,country_name&$format=json&$filter=(country_name eq 'Israel')

//Filter by id
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$select=country_id,country_name&$format=json&$filter=(country_id eq 1)

//count
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries/$count

//order by
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$select=country_id,country_name&$format=json&$orderby=country_name desc


//Insert recort
http://hldt-yanivt/YanivTZServices/AlisDataService.svc/t_countries?$format=json
POST
{
                "_id": 997,
                "_name": "Unknown997",
                "_abbreviation": null,
                "_cee": 0,
                "ent": 0,
                "iban_length": null
}