How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?

How could you execute DDL commands, such as ALTER or CREATE TABLE, against a database with ADO.NET?
by

1 Answer

Answer :

You must use a Command object to execute DDL commands. You can set the CommandType property to Text and enter the appropriate DDL command in the CommandText property. Then call Command.ExecuteNonQuery to execute the command.
by

Related questions

Briefly contrast connected and disconnected data access in ADO.NET.

Description : Briefly contrast connected and disconnected data access in ADO.NET.

Last Answer : In ADO.NET, connected data access is available through the DataReader, which is a lightweight class designed to provide very fast and efficient data access. It is severely limited, however, in ... to update the database and keeping the connection open just long enough to execute those commands.

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Description : What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Last Answer : SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. ... on top of the OLE layer, so it's not as fastest and efficient as SqlServer.NET.

What is the role of the DataReader class in ADO.NET connections?

Description : What is the role of the DataReader class in ADO.NET connections?

Last Answer : It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed.

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Description : What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

Last Answer : SQLServer.NET data provider is high-speed and robust, but requires SQL Server license purchased from Microsoft. OLE-DB.NET is universal for accessing other sources, like Oracle, DB2, Microsoft Access and Informix. ... on top of the OLE layer, so it's not as fastest and efficient as SqlServer.NET.

What is the role of the DataReader class in ADO.NET connections?

Description : What is the role of the DataReader class in ADO.NET connections?

Last Answer : It returns a read-only, forward-only rowset from the data source. A DataReader provides fast access when a forward-only sequential read is needed. 

Which of the following is/are the DDL statements? A) Create B) Drop C) Alter D) All of the above

Description : Which of the following is/are the DDL statements? A) Create B) Drop C) Alter D) All of the above

Last Answer : D) All of the above

Can we execute multiple catch blocks in C#?

Description : Can we execute multiple catch blocks in C#?

Last Answer : No. Once an exception has occurred it executes specific exception catch block and the control comes out.

Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Description : Anything that affects the database schema is a part of A) DML B) DCL C) DDL D) All of the above

Last Answer : D) All of the above

The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Description : The database schema is written in (A) HLL (B) DML (C) DDL (D) DCL

Last Answer : (C) DDL

DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema

Description : DBMS provides the facility of accessing data from a database through (A) DDL (B) DML (C) DBA (D) Schema 

Last Answer : (B) DML

Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 retains relation R, but deletes all tuples in R. III. C1 deletes not only all tuples of R, but also the schema for R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Description : Consider the following two commands C1 and C2 on the relation R from an SQL database:  C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III

Last Answer : (C) II and III only

. Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Description : . Which attack is an HTTP attack which allows attackers to access restricted directories and execute commands outside the web servers root directory? a. XSS attack b. Path Traversal attack c. MITM attack d. SQL Injection attack

Last Answer : d. SQL Injection attack

The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select.

Description : The statement in SQL which allows to change the definition of a table is (A) Alter. (B) Update. (C) Create. (D) select

Last Answer : (A) Alter.

Which one of the following tools is used to view the metadata information contained in a .NET assembly? Select Answer:  1. al.exe  2. ilasm.exe  3. vbx.exe  4. csc.exe  5. ildasm.exe

Description : Which one of the following tools is used to view the metadata information contained in a .NET assembly? Select Answer:  1. al.exe  2. ilasm.exe  3. vbx.exe  4. csc.exe  5. ildasm.exe

Last Answer :  5. ildasm.exe

In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed?

Description : In Visual Basic .NET or Visual C# programming, when would you use Structured Query Language (SQL)? How are they executed? 

Last Answer : ADO.NET handles most of the database communication for you behind-thescenes. You would only use SQL statements when generating ad-hoc queries for the database. You execute SQL statements by ... returning statements, such as DELETE, INSERT INTO, or UPDATE statements, use the ExecuteNonQuery method.

How do you enable your application to use .NET base class library members without referencing their fully qualified names?

Description : How do you enable your application to use .NET base class library members without referencing their fully qualified names?

Last Answer : Use the Imports keyword (Visual Basic .NET) or the using keyword (Visual C#) to make a .NET Framework namespace visible to your application. 

Briefly describe the major components of the .NET Framework and describe what each component does.

Description : Briefly describe the major components of the .NET Framework and describe what each component does.

Last Answer : The .NET Framework consists of two primary parts: the common language runtime, which manages application execution, enforces type safety, and manages memory reclamation, and the .NET base class library, which consists of thousands of predeveloped classes that can be used to build applications.

Option statements that are supported in VB.NET?

Description : Option statements that are supported in VB.NET?

Last Answer : Option Explicit:- By default, Option Explicit is on for VB.NET projects. It's a good programming practice to set Option Explicit on because it helps developers avoid implicitly declaring variables, and thus write ... . It's also a safer way to develop code, which is why most developers prefer it. 

What do you know about .NET assemblies?

Description : What do you know about .NET assemblies?

Last Answer : Answer: Assemblies are the smallest units of versioning and deployment in the .NET application. Assemblies are also the building blocks for programs such as Web services, Windows services, serviced components, and .NET remoting applications.

What is purpose of Assembly Linker or define SDK Tool in .NET Framework?

Description : What is purpose of Assembly Linker or define SDK Tool in .NET Framework?

Last Answer : Answer: In .NET whole the working should be with the helps of DLLs.So all of Visual Studio .Net compilers gernate assemblies or u can say dll.If we want to create an assembly with ... Studio .Net .This multi file can contain modules that are written in diffrenet langauage in one application.

What size is a .NET object?

Description : What size is a .NET object?

Last Answer : Each instance of a reference type has two fields maintained by the runtime - a method table pointer and a sync block. These are 4 bytes each on a 32-bit system, making a total of 8 bytes ... bytes, even for classes with no data (e.g. System.Object). Values types have no equivalent overhead. 

When should you call the garbage collector in .NET?

Description : When should you call the garbage collector in .NET?

Last Answer : As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice. 

What is the smallest unit of execution in .NET?

Description : What is the smallest unit of execution in .NET?

Last Answer : an Assembly. 

How is the DLL Hell problem solved in .NET?

Description : How is the DLL Hell problem solved in .NET? 

Last Answer : Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly.

How do you debug an ASP.NET Web application?

Description : How do you debug an ASP.NET Web application?

Last Answer : Attach the aspnet_wp.exe process to the DbgClr debugger. 

What debugging tools come with the .NET SDK?

Description : What debugging tools come with the .NET SDK?

Last Answer : 1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch. 2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

What’s the .NET collection class that allows an element to be accessed using a unique key?

Description : What’s the .NET collection class that allows an element to be accessed using a unique key? 

Last Answer : HashTable. 

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from?

Last Answer : System.Object.

When should you call the garbage collector in .NET?

Description : When should you call the garbage collector in .NET?

Last Answer : As a good rule, you should not call the garbage collector. However, you could call the garbage collector when you are done using a large object (or set of objects) to force the garbage collector to dispose of those very large objects from memory. However, this is usually not a good practice.

What is the smallest unit of execution in .NET?

Description : What is the smallest unit of execution in .NET?

Last Answer : an Assembly. 

How is the DLL Hell problem solved in .NET?

Description : How is the DLL Hell problem solved in .NET? 

Last Answer : Assembly versioning allows the application to specify not only the library it needs to run (which was available under Win32), but also the version of the assembly. 

How do you debug an ASP.NET Web application?

Description : How do you debug an ASP.NET Web application?

Last Answer : Attach the aspnet_wp.exe process to the DbgClr debugger.

What debugging tools come with the .NET SDK?

Description : What debugging tools come with the .NET SDK?

Last Answer : 1. CorDBG – command-line debugger. To use CorDbg, you must compile the original C# file using the /debug switch.   2. DbgCLR – graphic debugger. Visual Studio .NET uses the DbgCLR.

What’s the .NET collection class that allows an element to be accessed using a unique key?

Description : What’s the .NET collection class that allows an element to be accessed using a unique key?

Last Answer : HashTable.

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from? 

Last Answer : System.Object.

Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Description : Will we eventually see a .NET Framework-based version of Java as a competitor to C#?

Last Answer : Apparently not. Microsoft will never offer a complete Java environment because Sun has essentially required that Java licensees implement all of Java-something Microsoft will never do. (Why should it? Does ... she's working in a true Java environment because the familiar libraries won't be there. 

But won't most .NET developers eventually choose C# over Visual Basic.NET?

Description : But won't most .NET developers eventually choose C# over Visual Basic.NET? 

Last Answer : No. Because the power of the two languages is so similar, the primary factor for developers migrating to the .NET world will probably be the syntax they prefer. Since many more developers ... the dominant language for building Windows applications five years from now will still be Visual Basic. 

Isn't C# the native language of .NET?

Description : Isn't C# the native language of .NET?

Last Answer : Every language built on the .NET Framework must use the CLR. The CLR defines core language semantics, and so all of the languages built on it tend to have a great deal in common. The biggest choice a . ... just a little bit more-and so neither is the "native" .NET language. There is no such thing.

What’s the top .NET class that everything is derived from?

Description : What’s the top .NET class that everything is derived from?

Last Answer : System.Object.

What is the purpose of a bootstrapper application? When do you not need to create one?

Description : What is the purpose of a bootstrapper application? When do you not need to create one?

Last Answer : A bootstrapper application automatically detects if Windows Installer is installed on the target machine. If Windows Installer is not present, it installs Windows Installer before proceeding with the rest ... Installer 1.5 already installed) or have had Microsoft Installer 1.5 installed previously.

What is a native image? How do you create one?

Description : What is a native image? How do you create one?

Last Answer : A native image is a precompiled version of a .NET assembly. You can create a native image of your application by using the Ngen.exe utility.

What is a shared assembly? How would you create one?

Description : What is a shared assembly? How would you create one?

Last Answer : An assembly is an assembly of which only a single copy is installed per machine. This copy can be shared by multiple applications. To make an assembly a shared assembly, you must first assign it a strong name, and then install it to the global assembly cache.

Describe how to create localized versions of a form.

Description : Describe how to create localized versions of a form.

Last Answer : To create a localized version of a form, set the Localizable property to true. Then set the Language property to the language/region for which you want to create the localized form. Make ... be stored in resource files and loaded when the CurrentUICulture is set to the appropriate CultureInfo. 

Describe how to create a form or control with a nonrectangular shape.

Description : Describe how to create a form or control with a nonrectangular shape.

Last Answer : Set the Region property of the form or control to a Region object that contains the irregular shape. You can create a Region object from a GraphicsPath object.

What namespaces are necessary to create a localized application?

Description : What namespaces are necessary to create a localized application? 

Last Answer : System.Globalization and System.Resources.

If I have a constructor with a parameter, do I need to explicitly create a default constructor?

Description : If I have a constructor with a parameter, do I need to explicitly create a default constructor?

Last Answer : Yes

What namespaces are necessary to create a localized application?

Description : What namespaces are necessary to create a localized application?

Last Answer : System.Globalization and System.Resources. 

Can you create an instance of an interface?

Description : Can you create an instance of an interface?

Last Answer : No, you cannot create an instance of an interface.

What are the keyboard commands for saving database files ?

Description : What are the keyboard commands for saving database files ?

Last Answer : The keyboard command for saving database files is Ctrl + S