You can pass collections as Stored procedure parameter in SQL Server 2008. This is very useful in many scenarios.
Following are few options to send:
1. Easiest option is to send DataTable that has same column names as UDT in database
2. With little bit of extra code any custom collections can be passed as TVP [by popluating meta-data and SqlDataRecord collection].
Please see this excellent article for more details: http://www.sommarskog.se/arrays-in-sql-2008.html
Thanks to a friend of mine for sharing these details with me. I downloaded and tried few samples. These samples are extensive, very well documented and simple to follow.
Thanks to people behind this: http://1code.codeplex.com
In this article, focus is on web development using recent Microsoft Technologies. My goal is to provide clear practical approach that helps you use these new tools/technologies right away. To be specific I will be covering: Windows Azure, SQL Azure, Azure Queues, ASP.NET MVC2, EF 4.0, VS 2010, Ajax, JQuery/JQueryUI and Silverlight. I will also cover few common trends in web development: Blogs, CSS, debugging tools in browser etc
Read More… Web Development using Microsoft Technologies
In today’s fast changing technology, keeping up with technological changes is a challenge. Every time we try to keep up with technology changes, technology changes again. It is never ending chase to catch up with technology and that is what makes software development even more interesting. Focus of this article is to give developers, project managers a quick view of many of new Microsoft technologies out there and help them realize the value of these new technologies.
Read more.. Microsoft Technology Overview