Linq to Financial Markets : New Optimizing/Parsing Provider

submitted by dcarr 1 month, 19 days ago

blog.domaindotnet.com — We just finished the final iteration for this and went gold. Although this post has more marketing then I would normally post here, I at least wanted to let fellow Linq fanatics that our 'semi-secret' project with a few companies you might know has at least for now reached a milestone. And who could announce a new product without Silverlight (grin).. No seriously we love it. WPF was not all that compelling and XAML didn't look like much fun until we got our killer app in Silverlight. We even wrote a Linq version of the 'scribbler' code the deep zoom team posted if anyone would like it. Anyway, lots of good technical material will follow. We learned a lot and continue to learn a lot from dissecting the Linq to NHibernate project. What makes this work so fun is it demands optimization across different vendor web services. We do a kind of 'query optimizer' to decide how to fan out requests where we know the general characteristics of say 'asset classes' as data series vs. say a large list of equities. read more...

1 comment | category: Linq | Views: 19

IntelliSense for Expression Blend

published 2 months, 7 days ago, submitted by ligaz 2 months, 8 days ago

blogs.telerik.com — An add-in for Expression Blend 2.5 that adds IntelliSense for editing of XAML files. read more...

add a comment | category: Windows Presentation Foundation | Views: 164

ScottGu: First Look at Using Expression Blend with Silverlight 2

published 7 months, 13 days ago, submitted by Jemm 7 months, 13 days ago

weblogs.asp.net — In this first set of Silverlight tutorials I didn't use a visual design tool to build the UI, and instead focused on showing the underlying XAML UI markup (which I think helps to explain the core programming concepts better). Now that we've finished covering the basics - let's explore some of the tools we can use to be even more productive. read more...

1 comment | category: Silverlight | Views: 3

SQL 2005 Server Side Paging using CTE (Common Table Expression)

submitted by animaonline 7 months, 28 days ago

softscenario.blogspot.com — When a application want to show the result from an SQL-query as a paged view, i.e. showing ten or fifteen result on first page, then have a "next" function to show the next page of results. To minimize traffic over the network, it is best practice to do the paging on the SQL-server, so that only the results you want to show is sendt to the application. With SQL Server 2005 this is quite easy using the new CTE capabilities and the new ROW_NUMBER() function. (using the AdventureWorks example database for SQL-2005 http://codeplex.com/) Consider the following T-SQL to select out all employees from Person.Contact: SELECT [FirstName] ,[MiddleName] ,[LastName] ,[EmailAddress] FROM [Person].[Contact] This will result in 19972 rows returned, and the paging logic has to be done on the client application. not good.. so first we implement the ROW_NUMBER() function like this: SELECT ROW_NUMBER() OVER (Order by [Person].[Contact].[LastName]) AS RowID, [FirstName] ,[MiddleName] ,[LastName] ,[EmailAddress] FROM [Person].[Contact] This will create a unique RowID for each row in the result. Now we need to wrap the result in a CTE using just the WITH [ctename] AS () statement: WITH AllEmployees AS (SELECT ROW_NUMBER() OVER (Order by [Person].[Contact].[LastName]) AS RowID, [FirstName] ,[MiddleName] ,[LastName] ,[EmailAddress] FROM [Person].[Contact]) Now we have all the Employees in a in-memory table called AllEmployees, and we can select from this table as any other table, with all the common clauses. Simplest term: SELECT [FirstName] ,[MiddleName] ,[LastName] ,[EmailAddress] FROM AllEmployees Then, to use this for a Server-side paging solution, the simplest way we use the RowID to establish what rows to return, either by using DECLARE [varname] or by putting the whole code into a Parameterized StoredProcedure like this: CREATE PROC GetPagedEmployees (@NumbersOnPage INT=25,@PageNumb INT = 1) AS BEGIN WITH AllEmployees AS (SELECT ROW_NUMBER() OVER (Order by [Person].[Contact].[LastName]) AS RowID, [FirstName],[MiddleName],[LastName],[EmailAddress] FROM [Person].[Contact]) SELECT [FirstName],[MiddleName],[LastName],[EmailAddress] FROM AllEmployees WHERE RowID BETWEEN ((@PageNumb - 1) * @NumbersOnPage) + 1 AND @PageNumb * NumbersOnPage ORDER BY RowID END The parameter for this procedure is used for the paging and when executed it will return a result based on how many results per page, and what page read more...

add a comment | category: C# | Views: 10

Expression Studio on MSDN today!

submitted by Pluginbaby 1 year, 4 months ago

weblogs.asp.net — Expression Studio is available for Premium subscribers to MSDN Visual Studio Team Suite! read more...

add a comment | category: Community | Views: 0

LINQ To Flickr

published 1 year, 6 months ago, submitted by bashmohandes 1 year, 6 months ago

spellcoder.com — I had some free time at last, so I implemented a LINQ extension to Flickr, so you can query for photos by tags, creation date, user id or title, the implementation was really easy because I didn't have to use the Flickr API's directly as I found a good open source library for this called FlickrNet which I used as my infrastructure. So this is a sample of a query read more...

1 comment | category: C# | Views: 0

Microsoft Expression Web Ships

evanhoff.com — Expression Web is the successor to FrontPage and has a lot of features that were sorely missing: standards validation, strong css support, asp.net support, xml and xslt. While FrontPage was designed for the casual user, Expression Web was designed with the professional in mind. read more...

add a comment | category: ASP.NET | Views: 0