070-516 無料問題集「Microsoft TS: Accessing Data with Microsoft .NET Framework 4」

（A）using (var conn = new SqlConnection())
{
conn.ConnectionString = connString;
var cmd = new SqlCommand("SELECT * FROM BLOG", conn);
using (HostingEnvironment.Impersonate())
{
conn.Open();
}
var result = cmd.ExecuteScalar();
}

（B）using (var conn = new SqlConnection())
{
conn.ConnectionString = connString;
SqlCommand cmd = null;
using (HostingEnvironment.Impersonate())
{
cmd = new SqlCommand("SELECT * FROM BLOG", conn);
}
conn.Open();
var result = cmd.ExecuteScalar();
}

（C）using (var conn = new SqlConnection(connString))
{
var cmd = new SqlCommand ("SELECT * FROM BLOG, conn);
conn.Open();
using(HostingEnvironment.Impersonate())
{
var result = cmd.ExecuteScalar();
}
}

（D）using (var conn = new SqlConneccion())
{
using (HostingEnvironroent.Impersonate())
{
conn.ConnectionString = connString;
}
var cmd = new SqlCommand("SELECT * FROM BLOG, conn);
conn.Open() ;
var result = cmd.ExecuteScalar();
}

（A）partial void OnPostalCodeChanged(string value) {
PostalCode = GetValidValue<string>(value, "ValidatePostalCode", false, true) ;
}

（B）public string ValidatedPostalCode
{
set
{
ValidatePostalCode(value);
_PostalCode = value;
}
get
{
return _PostalCode;
}
}

（C）partial void OnPostalCodeChanging(string value) {
ValidatePostalCode(value);
}

（D）public string ValidatedPostalCode
{
set
{
_PostalCode = StructuralObject.SetValidValue("ValidatePostalCode", false);
}
get
{
return _PostalCode;
}
}

（A）while(context.ObjextStateManager.GetObjectStateEntry (cust).OriginalValues.IsDBNull(0)) {
if(count++ >2)
{
break;
}
context.SaveChanges();
}

（B）while(cust.EntityState == EntityState.Modified)
{
try
{
context.SaveChanges();
}
catch(Exception)
{
if(count++ > 2 && context.Connection.State ==
ConnectionState.Broken
{
throw new Exception();
}
}
}

（C）while(count++ < 3)
{
try
{
context.SaveChanges();
break;
}
catch(Exception)
{
}
}

（D）while(true)
{ context.SavingChanges += delegate(System.Object o, System.EventArgs e) {
if(count++ >2)
{
throw new Exception();
}
context.SaveChanges();
}
}

（A）var prods = ctx.ExecuteFunction<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

（B）var prods = ctx.CreateQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

（C）var prods = ctx.ExecuteStoreQuery<Product>(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

（D）var prods = ctx.ExecuteStoreCommand(prodQuery, new ObjectParameter("p0", "Road Bikes")).ToList();

（A）var unusedColors = context.Colors.Where(c => !c.Parts.Any()); context.DeleteObject(unusedColors); context.SaveChanges();

（B）context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges();

（C）var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){
context.DeleteObject(unused)
}
context.SaveChanges();

（D）context.Colors.ToList().RemoveAll(c => !c.Parts.Any()); context.SaveChanges();

（A）CommandBehavior.Default

（B）CommandBehavior.SequentialAccess

（C）CommandBehavior.KeyInfo

（D）CommandBehavior.SingleResult

（A）Apply the [DataContract(IsReference = false)] attribute to the entities.

（B）Apply the [DataContract(IsReference = true)] attribute to the entities.

（C）Apply the virtual keyword to the entity properties.

（D）Apply the [Serializable] attribute to the entities.

（A）Delete the EmployeeAccess entity, create a new property named CanAccessBuildings on the Employee entity, and add a mapping for the new property.

（B）Modify the .edmx file to include the following line of code. <NavigationProperty Name="Type" FromRole="EmployeeAccess" ToRole="Employee" />

（C）Create an inheritance relationship between the Employee and EmployeeAccess entities, and use CanAccessBuildings as an inheritance condition.

（D）Create a one-to-one association named CanAccessBuildingsAssociation between the EmployeeAccess entity and the Employee entity.

（A）.Take(startIndex)

（B）.Skip(startIndex)

（C）.OrderBy(x => x.Name)

（D）.Skip(pageSize)

（E）.Take(pageSize);

（A）<Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>

（B）<Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>

（C）<Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>

（D）<Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/> <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>

（A）Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=true;

（B）Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=true;

（C）Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=false;

（D）Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=false;

（A）Override the Delete operation of the customer entity.

（B）Use the ExecuteDynamicDelete method of the DataContext object.

（C）Modify the foreign key between the Customers and Orders tables to enable the ON DELETE CASCADE option.

（D）Remove the foreign key between the Customers and Orders tables.

（A）Timer time = (Timer)rdr[1];

（B）TimeSpan time = (TimeSpan)rdr[1];

（C）DateTime time = (DateTime)rdr[1];

（D）string time = (string)rdr[1];