Geeks With Blogs
Marcin Celej blog October 2007 Entries
SQL date filtering - between date from and to
I ve been recently creating few reports that required dates as parameters. It is quite common to have a report that must be provided range of dates (from and to). I investigated few reports that was created by my colleagues and I found those reports are not intuitive. Let me explain: When I see two dates that must be provided to a report I believe that when I provide the same date in from and to parameters it will show all data for the paricular day. See screenshot below: But to achieve this you ......

Posted On Wednesday, October 31, 2007 9:00 AM

Evaluating Community Server
I've been recently looking for a service that could be used as a medium of communication within a community. I do not want to type that I was looking for a community server as it is name of a product but I was. I needed it for Cracow .NET User Group that I am member of. I considered: Windows Sharepoint Services Community Server Google Groups Each of them has different set of features and can be applied to different requirements. All of them fullfil my requirements. I finally chose google groups because ......

Posted On Monday, October 29, 2007 11:08 AM

Google Code - google applications API
I've found that not too many of my coleagues know that almost every google application has its own API. E.g. the google calendar has API that is available in .NET. I am interested in the calendar automation so I hope I will find some time to use the Google Calendar APIs and Tools. Anyway all that is available for developers in google applications is avialable here: Just check it. Maybe you will find something interesting for you ......

Posted On Sunday, October 21, 2007 8:34 AM

WCF vs Remoting - sending plain objects
I've finally found some time to test WCF performance vs .NET Remoting in sending 'plain' objects. Here you can find my previous results of sending DataSet through the wires. The test project described in this article can be downloaded here. What I tested: Plain [Serializable] object Marked with or without [DataContract] attribute I tested client latency (not server throughput) What are my results: I hoped it will be different but it occurs that the .NET Remoting is better in sending plain objects ......

Posted On Friday, October 12, 2007 8:53 AM

Deploying WCF application
I finished my first set of WCF services that my enterpise application exposes. I am ready to deploy them and I found some problems. The .NET 3.0 is 'only' a set of libraries build on top of .NET 2.0. I thought all I need to do is to publish the libraries (I need WCF only) with my application in the bin folder - xcopy it. Unfortunatelly it occurs it's not so easy. I extracted the libraries out of my GAC and tried to execute my test app on a clean machine. It didn't work as I used app.config to configure ......

Posted On Tuesday, October 9, 2007 7:35 AM

Plugging-in application initialization code
Many times in my development live I had to plug-in some code into an existing application that should be xeceuted during startup / cleanup / ... . If you own the application you can always hardcode another line of code that invokes your static initialization class. But: What to do if a circular dependency occurs? Is the hardcoding clean? In such case there is a pattern (or snippet) that allows you to plug-in some dynamic invocation of code. Below is an example how to declare Init method in a MyStartup ......

Posted On Monday, October 8, 2007 7:05 AM

Tracking everyday activities
When you want to do something weekly do it daily - this is one of principles that I find very useful. Small steps allow you to achieve a snow ball effect - do something slowly step by step. Simple task executed every day during years allows to achieve something really big - this one I believe is the most important of those three. OK. Those are my principles but each time I try to follow those rules I find it difficult as flesh is weak and only mind is strong - I find it most difficult to do something ......

Posted On Thursday, October 4, 2007 8:33 AM

Evaluating expressions on XML data
Yesterday I implemented something like xml parsing in my application. The requirements were: Data is send to the application in form of xml using Web Service End-user should be able to extract some granular data out of the xml And here comes XPath. I added some configuration mechanism to my app so the end-user can provide xpath queries and save them in database. My WCF Service that looks exactly like an ordinary web service receives the xml data, searches for the XPath queries that should be run ......

Posted On Tuesday, October 2, 2007 8:33 AM

Copyright © Marcin Celej | Powered by: