WCF Services are considered as loosely coupled because WCF services are not tightly bound to a particular protocol, encoding format, or hosting environment. All of these are configurable. At the time of designing WCF services, we don’t have to worry about what protocol, encoding format, or hosting environment to use to expose the service. We can worry about all these at the time of deployment.
A LEFT JOIN will take ALL values from the first declared table and matching values from the second declared table based on the column the join has been declared on. An INNER JOIN will take only matching values from both tables.
Create a view in SQL server for take a random record CREATE VIEW RandomView AS SELECT NEWID() As ID Then create a functin in SQL server CREATE FUNCTION GetNewId ( ) RETURNS uniqueidentifier AS BEGIN RETURN (SELECT ID FROM RandomView) END The view is required because it’s not possible to directly use NEWID in a scalar function. You can then map the GetNewId user-defined function using LINQ to SQL’s Function attribute. Again, see chapter 8 for the details. That’s it! You can now write LINQ queries as usual. Here is an example to pick a random object: var tool = … Click here to continue reading.
Scalibility – The same Microsoft SQL Server 2000 database engine operates on Microsoft Windows 2000 Professional, Microsoft Windows 2000 Server, Microsoft Windows 2000 Advanced Server, Windows 98, and Windows Millennium Edition. It also runs on all editions of Microsoft Windows NT version 4.0. The database engine is a robust server that can manage terabyte-sized databases accessed by thousands of users. Availability – SQL Server 2000 can maintain the extremely high levels of availability required by large Web sites and enterprise systems. Integration -The SQL Server 2000 TCP/IP Sockets communications support can be integrated with Microsoft Proxy Server to implement secure … Click here to continue reading.
Structure: Initially (in C) a structure was used to bundle different type of data types together to perform a particular functionality. But C++ extended the structure to contain functions also. The major difference is that all declarations inside a structure are by default public. Class: Class is a successor of Structure. By default all the members inside the class are private.