Configuring SQL server instance to listen to a specific port as instance port can change. SQL Serer default instance listens to port 1433. However if Named Instance is configured then by default the port is changing dynamically. To enable SQL server to listen to port, ALL the IP Addresses for the instance including the Loopback and IPALL needs to be changed to the specified Port ... See Below:
How to: Configure a Server to Listen on a Specific TCP Port (SQL Server Configuration Manager): "In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll. One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer. Right-click each address, and then click Properties to identify the IP address that you want to configure.
Something has to be sacrificed in every release of EF and this time it is transactions! ... some hidden way of exposing the SaveOptions while using the DBContext IObjectContextAdapter interface.
Howeve, it turns out that we don't need to use the SaveOptions anymore if dealing with SQL server 2008. In SQL server 2008 using the TransactionScope DOES NOT escalates the transaction to Distributed Transaction anymore. Wrapping up more than one DBContexts inside a TransactionScope works fine!
I had a scenario where needed to loop through all the projects and then all it tasks and getting the error in Entity framework 4.2: "There is already an open DataReader associated with this Command which must be closed first."
The solution is to set the lazy loading off or add MARS to the connection string. Strange?
WCF RIA Services is using "Astoria" to remote an IDataService interface to a Silverlight client. It's RPC CRUD over Http complete with client side proxy objects."
When trying to install an application that requires .Net 4 client profile in a Windows 2003 machine there is a run time error. The trick is to set the 'State' registry key to 0x23c00
After changing the registry the installation goes on and then fails again with an error: ""Blocking Issues:You must install the 32-bit Windows Imaging Component (WIC) before you run Setup. Please visit the <A HREF="http://go.microsoft.com/fwlink/?LinkId=162643&clcid=0x409">Microsoft Download Center</A> to install WIC, and then rerun Setup.""
;-) Can't be more fun!!! Just run into this funny question in one of the forums:
The client is going live by 12 pm tomorrow and the tech guys have just realised that the the Business layer needs a WCF facade to handle 3-tier physical deployment!! hahaha...
Wow ... What a crazy addin for .net Refelector. It enables to change the function definitions, add new functions and compile the assembly!!! ... do we need hot fixes (hotfix) anymore? haha
Great article by the GUY ;-) Martin Fowler about the MVP architecture. ... MVP is the base for MVC and also MVVM etc. This article is great as shows the flow of events using UML sequence diagrams:
Great article by the GUY ;-) Martin Fowler about the MVP architecture. ... MVP is the base for MVC and also MVVM etc. This article is great as shows the flow of events using UML sequence diagrams: