travanj 2008 - Posts
On WinDays 2008 conference in Opatija last week I delivered a presentation about ADO.NET Data Services. You can download samples from presentation here: ADONETServicesDemos.zip.
We have a new central site for the whole croatian community (Čakovec, Dubrovnik, IT Pro, Osijek, Rijeka, Poreč, Split, Zadar, Zagreb) the place for aggregating news and announcements from all groups.
And also a start page for registering and start using all our services like blogs, wiki, video etc. Visit http://cro.mscommunity.net and explore our work. Work on site is in progress and new features will be added soon.
I recently had to deploy DB that was developed in SQL Server 2005 Express to SQL Server 2000. The little tool i found help me a lot.
It's a Database Publishing Wizard - part of SQL Server Hosting Toolkit. The toolkit has a wider purpose but the DB Publishing wizard is really usefull because it can script database (both 2000 and 2005, and both schemas, objects and data) with customized syntax for target SQL Server version. Writing scripts by hand with little changes in syntax or object names changed (sys.objects - sysobjects) can make you a lot of trouble and this tool can save you a lot of your time. And of course - time is money - isn't it? Or could I say - time is free time ;-)
The International Organization for Standardization (ISO) and the International Electrotechnical Commission (IEC) announced, on April 2, that national bodies voted to approve Office Open XML as an open international standard. If the procedure continues with usual timing the Open XML would become the ISO standard in next months.
For developers it can only mean: start learn Open XML API cause it would be used more and more in a many and different scenarios ;-)
ADO.NET Data Services framework lets you publish data in a REST (Representational State Transfer) style. REST style in a short means: use standard protocol for conversation (today: HTTP - GET. POST, DELETE...) and queries (URIs) and drive data in standard format (today: XML, JSON).
The most tutorials and starter docs are showing publishing ADO.NET Data Service (it is really only special form of WCF service) over ADO.NET Entity Model and you could take "by default" that ADO.NET Data Services are for publishing Database data only. But it is not! I agree with Christian Weyer: Data != Database in ADO.NET Data Services. We could expose data from any source (other web service, hardcoded, any database etc.).
The only requirement for doing this is to use Microsoft.Data.Web namespace, [DataWebKey] for marking one of the class properties as key and use IQueryable interface with AsQueryable() method for making the DataContext for ADO.NET Data Service from our class.
In attached sample DataSvcClass.zip you could see that the class Event:
exposed over ADO.NET Data Service can be URI queryed over HTTP.
Download sample web site DataSvcClass.zip and try to send URI query to service for querying Event class.