Written by Are you looking for Best Online training institute for Microsoft .Net? We are providing training for the students from whole world irrespective of place and location. Our instructors are making it possible with the help of their unmatched skills and technical knowledge. You can attend our training classes even after completion of the training, if you have any doubt ? don’t worry our support team is always ready to clear your doubt. We have a customer support service 24/7/365 only for you.
What is XML Namespace?
XML Namespaces provide a method to avoid element name conflicts.
XML Namespaces-The xmlns Attribute
When using prefixes in XML, a so-called namespace for the prefix must be defined.
The namespace is defined by the xmlns attribute in the start tag of an element.
The namespace declaration has the following syntax. xmlns:prefix=”URI“.
What’s the difference between DELETE TABLE andTRUNCATE TABLE commands?
Following are difference between them :-
- DELETE TABLE syntax logs the deletes thus making the delete operationslow.TRUNCATE table does not log any information but it logs informationabout deallocation of data page of the table.So TRUNCATE table is faster ascompared to delete table.
- DELETE table can be rolled back while TRUNCATE can not be.
- DELETE table can have criteria while TRUNCATE can not.
- TRUNCATE table can not triggers.
What is a application domain?
Previously “PROCESS” where used as security boundaries.One process has its ownvirtual memory and does not over lap the other process virtual memory , due to this oneprocess can not crash the other process.So any problem or error in one process does notaffect the other process.In .NET they went one step ahead introducing applicationdomains.In application domains multiple application can run in same process with outinfluencing each other.If one of the application domains throws error it does not affectthe other application domains.To invoke method in a object running in different applicationdomain .NET remoting is used.
What’s the use of CommandBuilder ?
CommandBuilder builds “Parameter” objects automatically.Below is a simple code whichuses commandbuilder to load its parameter object’s.
Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAdapter) pobjCommandBuilder.DeriveParameters(pobjCommand)
Be careful while using “DeriveParameters” method as it needs a extra trip to the Datastorewhich can be very inefficient.