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
54 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.9
    2428 Jobs 1208 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
    343 Jobs 237 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.6
    471 Jobs 284 Reviews
    $0 in 0 Day
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.7
    75 Jobs 29 Reviews
    $0 in 0 Day