News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

MCPD- Exam 70-516: Accessing Data with Microsoft .NET Framework 4

  1. DSACryptoServiceProvider

  2. AESCryptoServiceProvider

  3. MD5CryptoServiceProvider

  4. SHA1CryptoServiceProvider

Answer: Answer is b

  1. Encrypt the connection string.

  2. Use encryption to store sensitive data in the database.

  3. Use Secure Sockets Layer (SSL) to establish connections to the database.

  4. Use Internet Protocol Security (IPSec) to secure the communication channel.

Answer: Answer is c

  1. Call the query's Execute method by using the MergeOptions.AppendOnly option

  2. Call the query's Execute method by using the MergeOptions.OverwriteChanges option

  3. Call the Refresh method of ObjectContext by using the RefreshMode.StoreWins option.

  4. Call the Refresh method of ObjectContext by using the RefreshMode.ClientWins option.

Answer: Answer is d

  1. ObjectContext.Refresh

  2. DataContext.AcceptAllChanges

  3. ObjectStateEntry.AcceptChanges

  4. ObjectStateEntry.SetModifiedProperty

Answer: Answer is d

  1. Copy the updated .edmx file to the production server

  2. Copy the updated .csdl file to the production server.

  3. Copy the updated .ssdl file to the production server.

  4. Recompile the application and redeploy the modified assembly file.

Answer: Answer is d

  1. Modify the connection string in the application's .config file to refer to the absolute physical path to the . edmx file.

  2. Modify the connection string in the application's .config file to refer to the relative path to the .edmx file.

  3. Set the value of the .edmx file's Metadata Artifact Processing property to Copy to Output Directory.

  4. Set the value of the .edmx file's Build Action property to Copy to Output.

Answer: Answer is c

01AdventureWorksEntities context = New AdventureWorksEntities (http://localhost:1234/AdventureWorks.
svc );
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;

You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source. "Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?

  1. context.MergeOption = MergeOption.AppendOnly;
  2. context.MergeOption = MergeOption.PreserveChanges;
  3. context.MergeOption = MergeOption.OverwriteChanges;
  4. context.MergeOption = MergeOption.NoTracking;
Answer: Answer is b

  1. Call the EnlistVolatile method of the Transaction class.

  2. Call the EnlistDurable method of the Transaction class.

  3. Call the Reenlist method of the TransactionManager class.

  4. Call the RecoveryComplete method of the TransactionManager class.

Answer: Answer is c

  1. Call the EnlistVolatile method of the Transaction class.

  2. Call the EnlistDurable method of the Transaction class.

  3. Call the Reenlist method of the TransactionManager class.

  4. Call the RecoveryComplete method of the TransactionManager class.

Answer: Answer is b

  1. //Add the following conceptual model function returns the number of years since an instructor was hired

    <Function Name="YearsSince" ReturnType="Edm.Int32">
    <Parameter Name="date" Type="Edm.DateTime" />
    <DefiningExpression>
    Year(CurrentDateTime()) - Year(date)
    </DefiningExpression>
    </Function>

    // add the following method to your application and use an EdmFunctionAttribute to map it to the conceptual model function:

    [EdmFunction("SchoolModel", "YearsSince")]
    public static int YearsSince(DateTime date)
    {
    throw new NotSupportedException("Direct calls are not supported.");
    }
  2. //Add the following conceptual model function returns the number of years since an instructor was hired

    <Function Name="YearsSince" ReturnType="Edm.Int32">
    <Parameter Name="date" Type="Edm.DateTime" />
    <DefiningExpression>
    Year(CurrentDateTime()) - Year(date)
    </DefiningExpression>
    </Function>

    // add the following method to your application and use an EdmFunctionAttribute to map it to the conceptual model function:

    [EdmFunction("SchoolModel", "YearsSince")]
    public static int YearsSince(DateTime date)
    {
    return CurrentDateTime() - Year(date);
    }
  3. //Add the following conceptual model function returns the number of years since an instructor was hired

    <Function Name="YearsSince" ReturnType="Edm.Int32">
    <Parameter Name="date" Type="Edm.DateTime" />
    <DefiningExpression>
    YearsSince(DateTime date)
    </DefiningExpression>
    </Function>

    // add the following method to your application and use an EdmFunctionAttribute to map it to the conceptual model function:

    [EdmFunction("SchoolModel", "YearsSince")]
    public static int YearsSince(DateTime date)
    {
    return CurrentDateTime() - Year(date);
    }
  4. Use the Entity Data Model Designer to create a complex property named YearsSinceNow that can be accessed throuqh the LINQ to Entites query at a Later time

Answer: Answer is a

Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;