1.which ado.net object is a forward only cursor and is

Project Description:

1.which ado.net object is a forward only cursor and is connected to the database while the cursor is open? a.dbdatareader b.dataset c.datatable d.dataadapter 2.which ado.net command object’s property would you use when a query returns the sum of a column in a table? a.executenonquery b.executedatareader c.executescalar d.execute 3.which ado.net object is a fully traversable cursor and is disconnected from the database? a.dbdatareader b.dataset c.datatable d.dataadapter 4.which method of a dataadapter is used to populate a dataset? a.populate b.fill c.load d.datasets[0].fill 5.which property of an ado.net dataadapter is used to insert records in a database? a.inserttext b.inserttype c.insertcommand d.insertdatatable 6.which ado.net command object’s property would you use when a query returns the sum of a column in a table? a.executenonquery b.executedatareader c.executescalar d.execute7.when using the ado.net entity framework you create a model that represents the object in the database. what class does the model inherit from? a.dbcontext b.dbset c.model d.connection 8.how are stored procedures represented in the ado.net entity framework? a.a class is created with the same name as the stored procedure, and the execute method is implemented. b.a method is added to the model that is the same name as the stored procedure. c.stored procedures cannot be called from the ado.net entity framework. d.a method is created in the entity class for the table in the stored procedure. 9.which code uses the ado.net entity framework to add a record to the database? a. using (northwindsentities db = new northwindsentities()) { category category = new category() { categoryname = "alcohol", description = "happy beverages" }; db.categories.add(category); db.savechanges(); } b. using (northwindsentities db = new northwindsentities()) { category category = new category() { categoryname = "alcohol", description = "happy beverages" }; db.categories.add(category); db.insertrecords (); } c. using (northwindsentities db = new northwindsentities()) { category category = new category(){ categoryname = "alcohol", description = "happy beverages" }; db.categories.insert (category); db.savechanges(); } d. using (northwindsentities db = new northwindsentities()) { category category = new category() { categoryname = "alcohol", description = "happy beverages" }; db.categories.insert(category); db.insertrecords(); } 10.which code uses the ado.net entity framework to update a record in the database? a. category category = db.categories.first(c =_ c.categoryname == "alcohol"); category.description = "happy people"; db.updaterecords (); b. category category = db.categories.first(c =_ c.categoryname == "alcohol"); category.description = "happy people"; db.categories.updaterecords(); c. category category = db.categories.first(c =_ c.categoryname == "alcohol"); category.description = "happy people"; db.savechanges(); d.category category = db.categories.first(c =_ c.categoryname == "alcohol"); category.description = "happy people"; db.categories.savechanges();
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 13
1 Current viewersl
16 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    1992 Jobs 1016 Reviews
    $0 in 0 Day
  • 4.0
    72 Jobs 31 Reviews
    $0 in 0 Day
  • 4.9
    95 Jobs 45 Reviews
    $0 in 0 Day
  • 4.8
    290 Jobs 208 Reviews
    $0 in 0 Day
  • 4.8
    60 Jobs 32 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day
  • 4.6
    8 Jobs 5 Reviews
    $0 in 0 Day
  • 4.5
    355 Jobs 236 Reviews
    $0 in 0 Day
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.7
    74 Jobs 28 Reviews
    $0 in 0 Day