http://george.tsiokos.com on c#, .NET, SharePoint, Windows and OS X Thu, 09 Oct 2008 13:51:07 +0000 http://backend.userland.com/rss092 en Auto-Implemented properties are great, until you need to implement custom get or set logic. I love the ability to make the field an implementation detail, until you need to implement the property. What if you could continue to hide the field, like this:public string FirstName { get { ... http://george.tsiokos.com/posts/2008/10/07/c-sharp-language-request-for-properties/ When a LINQ to SQL query contains a Union or Concat with a second query, and the second query references a column twice, a SqlException will occur. var a = from address in dc.Addresses select new { ID = address.AddressID, Address1 = address.AddressLine1, Address2 = address.AddressLine2, }; var b = from address in dc.Addresses select new { ID = ... http://george.tsiokos.com/posts/2008/09/10/linq-to-sql-produces-incorrect-tsql-when-using-union-or-concat/ Last year, Scott Guthrie stated “You can actually override the raw SQL that LINQ to SQL uses if you want absolute control over the SQL executed”, but I can’t find documentation describing an extensibility method. I would like to modify the following LINQ to SQL query: using (NorthwindContext northwind = new NorthwindContext ... http://george.tsiokos.com/posts/2008/09/09/extending-linq-to-sql/ nComet is a .NET implementation of the Comet (reverse-AJAX push) architecture. This server-side pipeline uses long-lived client-initiated HTTP connections to push messages to the client. Once the client receives a response, it immediately opens another HTTP request, which the server holds until a message is ready. This architecture allows the ... http://george.tsiokos.com/posts/2008/07/09/introducing-ncomet/ The code generation performed by MSLinqToSQLGenerator or SQLMetal generates weird property code. For example, in AdvantureWorks, the table Product has a column ProductLine. Using the tools that come with LINQ to SQL, this column translates to a property: [Column(Storage="_ProductLine", DbType="NChar(2)")] public string ProductLine { get { return this._ProductLine; ... http://george.tsiokos.com/posts/2008/04/09/linq-to-sql-code-generation-bug/ I couldn't figure out a way to perform the equivalent of WHERE Column1 IN ('A', 'B', 'C') in LINQ, where ('A', 'B', 'C') would represent an IEnumerable<T> where T is the type of Column1. So I thought it was an excellent time to write an extension method that would generate ... http://george.tsiokos.com/posts/2007/11/30/linq-where-x-in/ The last message to be written to the console was: “Error : Index was outside the bounds of the array.”. To reproduce this bug, create this stored procedure and run SqlMetal against it: CREATE PROCEDURE [dbo].[ThisProcedureWillCauseSqlMetalToCrash] AS BEGIN SET NOCOUNT ON; SELECT 1 [A], 2 [ ], 3 [C] END Applies to: Visual Studio 2008 RTM Microsoft Windows SDK ... http://george.tsiokos.com/posts/2007/11/28/sqlmetal-crashes-when-a-column-name-in-the-result-set-is-blank/ Here are the bug fixes I wrote for Enterprise Library 3.0 - April 2007, related to using the EntLibLoggingProxyTraceListener to proxy .NET TraceListener messages to enterprise library and logging over MSMQ via MsmqTraceListener. In Microsoft. Practices. EnterpriseLibrary. Logging. TraceListeners. EntLibLoggingProxyTraceListener, comment out properties.Add(TraceEventCacheKey, eventCache); // line 66 & 146 (fix for SerializationException) In ... http://george.tsiokos.com/posts/2007/05/21/some-enterprise-library-30-april-2007-bug-fixes/ Microsoft: When a ClickOnce application is updating on startup, please display a wait cursor, or some indication to the user that the application is loading - the progress bar currently disappears after the new version is downloaded. On older computers, the time between the progress bar dissapearing and the application loading ... http://george.tsiokos.com/posts/2007/03/16/clickonce_progress_disappear/ Setting the CachePolicy to the default HttpRequestCacheLevel causes an exception internal to HttpWebRequest when a web application is running with an application pool configured to use a custom identity. For example: HttpWebRequest request = …; request.CachePolicy = new System.Net.Cache.HttpRequestCachePolicy ( System.Net.Cache.HttpRequestCacheLevel.Default); request.GetResponse (); GetResponse () throws a WebException: “The ... http://george.tsiokos.com/posts/2007/03/15/nullreferenceexception_httpwebrequest_cachepolicy/ Here's a number of inconsistencies with exception constructors: The message parameter is first and paramName is second for one of ArgumentException's constructors. public ArgumentException(string message, string paramName); These exceptions inherit ArgumentException: In one of ArgumentOutOfRangeException's constructors, paramName is first and message is second. public ArgumentOutOfRangeException(string paramName, string message);In one of InvalidEnumArgumentException's constructors, argumentName is used ... http://george.tsiokos.com/posts/2007/03/14/what-happened-here/ I've been working with a WCF service and wanted to change the name of the service without changing the class name (TypeName). Every example I've seen shows that the name of the type equals the name of the service. The service is hosted in IIS, and the web.config is configured as: <system.serviceModel><services> <service ... http://george.tsiokos.com/posts/2007/03/13/wcf-service-name/ Just looking over the latest Orcas CTP I noticed something new: Synchronization Services lets you synchronize data from disparate sources over two-tier, N-tier, and service-based architectures. Instead of only replicating a database and its schema, the Synchronization Services application programming interface (API) provides a set of components to synchronize data between ... http://george.tsiokos.com/posts/2007/03/12/orcas_ctp_synchronization_services/ Just saw the latest episode of Heroes: The Company Man. Not only is this best episode of Heroes yet, it’s officially the best TV show, ever. Watch the full series premiere for free, or, get the entire season pass on iTunes. http://george.tsiokos.com/posts/2007/02/26/heroes/ In Programming .NET Components, Juval Löwy explains the reasoning behind and how to use the EventHandlerList class (It’s used internally in the Control & derived classes to store event subscriptions). I found that this architecture easily supports the removal of all behavior*: public static void ClearEventHandlerList (Component component) { ... http://george.tsiokos.com/posts/2006/11/21/removing-a-controls-behavior/ The shutdown notifications need additional work in Windows Vista RC1: Run cmd.exe with administrative privileges Run the following command: shutdown /s /t 600 Abort the shutdown with this command: shutdown /a Notification of an aborted system shutdown in Beta 2 had a strange title: Luckily, Microsoft has enhanced the title in RC1, but there is still room ... http://george.tsiokos.com/posts/2006/09/11/vista-rc1-shutdown-notification/ The Internet is not a big truck. It’s a series of tubes. - Ted Stevens Check out this clip from The Daily Show where John Hodgman explains the technical implementation of the Internet and why we need network neutrality: http://george.tsiokos.com/posts/2006/09/01/network-neutrality/ I received a lot of JPEG images taken by multiple cameras at my daughter's birthday party. My first thought was to import them in to Aperture as a birthday album. Unfortunately, these images contained incorrect capture dates preventing me from organized them in chronological order. Digital cameras have a clock and ... http://george.tsiokos.com/posts/2006/08/28/camera-metadata/ Daring fireball reveals hypocrisy on a comparison between Windows and Mac OS X. After reading both posts, I’ve found more inaccuracies with Paul Thurrott's preview of the new Mac OS X. Time Machine is a truly good idea: It helps you automatically back up everything on your system and restore earlier ... http://george.tsiokos.com/posts/2006/08/20/more-inaccuracies/ Find out what someone looks like based on their email address! Most people have online relationships with several people whom they have never met in person. Most of the time, all you have is their email address. email2face is an online directory of photos that are linked to people's email ... http://george.tsiokos.com/posts/2006/03/27/email2face-is-live/ If the configuration namespace is referenced in an app.config, you may receive the following error messages in the system event log: Syntax error in manifest or policy file file name on line 2. The manifest file root element must be assembly. The application failed to launch because of an invalid manifest. Generate Activation ... http://george.tsiokos.com/posts/2006/01/12/sxs/ When attempting to install a ClickOnce application when using mandatory user profiles, you may receive an error message similar to the following: The manifest may not be valid or the file could not be opened Manifest XML signature is not valid The profile for the user is a temporary profile Please rate and validate ... http://george.tsiokos.com/posts/2006/01/12/clickonce-does-not-support-mandatory-user-profiles/ I didn’t think the new iterator pattern in c# 2.0 would be as useful as the other new features. I though, how many problems are solved with enumerators? Well, here is a great example where creating an enumerator isn’t the problem being solved, it’s an elegant HTTP application pipeline that ... http://george.tsiokos.com/posts/2005/08/29/yield-return-elegant-code/ If you’ve used SQL Server, you’ve probably used the ISNULL function. It replaces NULL with the specified replacement value. In .NET 2.0, c# gets this capability with a new ?? operator – the null coalescing operator. So when you define nullable types, you can check for null, and replace it ... http://george.tsiokos.com/posts/2005/08/27/isnull-in-c-sharp/ I've always wanted to go to the PDC, i’ve just never been in the position to go. For example, for the 2000 Professional Developer’s Conference (PDC), I was an undergraduate student at the University of Central Florida working as a professor’s assistant, making just enough money to pay the bills. ... http://george.tsiokos.com/posts/2005/08/15/pdc-2005/ Some guy has posted a list of everyone's pin! read more | digg story http://george.tsiokos.com/posts/2005/07/12/time-to-change-your-pin/ I have released a new version of my Windows SharePoint Services RSS/ATOM reader. It now supports the two most requested features: items optionally displayed in a new window & optionally displaying item descriptions. As with previous versions, you may generate DWP files for use in SharePoint directly from my website ... http://george.tsiokos.com/posts/2005/07/04/wss-rss-14/ It's been a while since my last post. I've accepted a position with ASPSOFT and have been extremely busy since March. I'm hard at work on a new community site for .NET development that should ease coding for multiple versions of .NET as well as the transition to new versions ... http://george.tsiokos.com/posts/2005/05/24/busy-busy-and-busy/ Did you ever get this exception when using HTTPS? System.Net.WebException: The underlying connection was closed: Could not establish trust relationship with remote server. This usually happens on a client calling a secure web service with a user generated certificate. Did you write this code to solve the problem? public class TerribleCertificatePolicy : System.Net.ICertificatePolicy ... http://george.tsiokos.com/posts/2005/02/10/net-https-security/ I had a great time at the Florida Code Camp 2005. The Indigo presentation was awesome – I’d really like to see some more details on the new Windows Activation Service that Indigo supports for application hosting. I was also particularly impressed with Visual Studio Team System’s ability to get ... http://george.tsiokos.com/posts/2005/02/09/florida-code-camp-2005/ SharePoint RSS/ATOM reader XSL converts RSS to a native Windows SharePoint Services DataViewWebPart DWP file. No binaries, installation or server configuration necessary. Supports RSS versions 0.90, 0.91, 0.92, 1.0, and 2.0. Supports the Atom Syndication Format 0.3. Supports Microsoft's Channel Definition Format. Html output is similar to the links list summary view. Title, Description, and DetailLink come ... http://george.tsiokos.com/posts/2005/01/11/wss-rss/ "Games against similarly skilled opponents and with similarly skilled teammates tend to be the most fun." - Bungie I disagree with that statement. I find that games against slightly less skilled opponents are the most fun. On Wednesday, I had some great scores and my level went from 4 to 5 ... http://george.tsiokos.com/posts/2005/01/09/halo-2-was-depressing-yesterday/ I've finally gotten around to writing my first entry for the New Year. I’ve got many things planned for this website as well as some freeware and commercial apps coming later this year. For example, typereference.com will contain the most comprehensive class library documentation for .NET as well as showcase ... http://george.tsiokos.com/posts/2005/01/09/not-just-another-year/ I wanted to test collection equality disregarding order. One int array of 1,2,3,4 and another of 4,2,3,1 would be equal. Also, collections of collections would be compared only by their items and the number of times those items appear in any collection. char[] charsA = new char[] { 'a', 'b', 'c', ... http://george.tsiokos.com/posts/2004/12/03/collection-equality-regardless-of-item-order/ 5.CompareTo(4); // returns 1 (greater than) 5.CompareTo(5); // returns 0 (equal) 5.CompareTo(6); // returns -1 (less than) // A class will only compare to its same type. 5.CompareTo('c'); // Throws ArgumentException I created the following class to use instead of the default Comparer class (which just calls the CompareTo method of each object implementing IComparable) ... http://george.tsiokos.com/posts/2004/12/02/missing-icomparer/ The Microsoft KB example code or class library documentation do not explain how to efficiently return a table’s schema. For example, this code follows the documentation: DataTable dataTable = null; using(IDbConnection dbConnection = (IDbConnection)database.Unwrap()) { dbConnection.Open(); using (IDbCommand dbCommand = dbConnection.CreateCommand()) { dbCommand.CommandType = CommandType.Text; ... http://george.tsiokos.com/posts/2004/12/01/idatareader-getschematable/ SQLite was the topic at the last ONETUG meeting here in Orlando, FL. I was surprised to find that SQLite was exactly what I was looking for in a client-side database - slim and easy to deploy. There’s also an ADO.NET data provider open-source project where they provide everything you ... http://george.tsiokos.com/posts/2004/10/24/sqlite/ Countrywide wants me to believe that making more payments on my loan will benefit me. For example, with PayPlan/52, I could pay off my mortgage every week. You may be able to save thousands of dollars in interest payments and reduce the term of your loan by several years, or ... http://george.tsiokos.com/posts/2004/09/11/countrywide-payplan-52/ Back in 2002 I posted a question in Usenet about the IPAddress class being serializable, but not serializing in ASP.NET. I just found the post, and noticed that no one responded with the reason why. So, here it is: There are two types of serialization in .NET: System.Runtime.Serialization and System.Xml.Serialization. Runtime ... http://george.tsiokos.com/posts/2004/09/06/ipaddress-class-serializable/ Probably reference. Checking for value equality is unintuitive - by default == is a reference equality check.object a = 1;object b = 1;Assert.IsFalse (a == b);Object a doesn't equal object b since boxing a as object created once instance, and boxing b created another. Since == is a "reference type ... http://george.tsiokos.com/posts/2004/08/26/reference-or-value-equality/ If you take any one of the many RSS libraries, including my own RSS.NET, ATOM libraries, or even OPML libraries, you find mostly the same functionality. Each read and write to a specific XML format. Some take advantage of the XML libraries provided by the environment, and some even read ... http://george.tsiokos.com/posts/2004/07/15/xml-object-libraries-are-deprecated/ The services that George provides to you are subject to the following Terms of Use (TOU). George reserves the right to update the TOU at any time without notice to you. The most current version of the TOU can be reviewed here. Through his network of websites, George provides you with ... http://george.tsiokos.com/posts/2004/07/09/terms-of-use/