Skip to main content

Posts

Showing posts from October, 2007

An Introduction of LINQ [ORM in DOT NET]

L anguage In tegration Q uery: The way to Map Object with Relation. OOP is quite popular and due to its advantage but when we think about the Database driven application again we need to write repeated and massive code for application the same action Add, Delete and update for all the table of database. Now in a LINQ the DataContext is take care of all the manipulation of relation. We can map Student table with Student Class. Take a case study example. Project: Test Select, Insert, Update, and Delete action in LINQ Request: Dot net Framework 3.0/3.5, Patched of LINQ, Knowledge of OOP, ASP.NET and C# and VS 2005 IDE.

SQL Serve 2005 Replication

Replication is sound good to manage the database in synchronized way. SQL Server Provides the different ways to Replicate the database Snapshot, Transactional and Merge are some of them. In this post we will discuss about the Snapshot Replication. It can be useful to whom are interested in MCTS 70 431 certificate. [source MCTS Trainig Guide] Introduction SQL Server database replication is a set of technologies for copying and distributing data and database objects from one database to one or more other databases and keeping the databases synchronized. Using replication technologies, you can increase the availability of your software solutions by geographically distributing your data, making applications more resilient to communication failures. You can also use replication to distribute the data-access workload across multiple servers or to support remote clients. Key Term Articles: The most basic unit of replication, represents the database object that is replicated like ...