Interview Questions.

Question 1. What Is Entity Framework?

Answer :

Entity Framework is an additional layer among application and database that permits the builders to application in opposition to the conceptual application version in preference to programming immediately in opposition to the relational storage schema.

Question 2. Will There Be Any Issues Adding A Table Without Primary Keys To A Data Model?

Answer :

Every entity must have a key, even inside the case in which the entity maps to a view. When you use the Entity Designer to create or replace a model, the training which can be generated inherit from EntityObject, which requires EntityKey. So, we need to have a number one key inside the table to feature it to the information model.

XML Interview Questions
Question 3. How Do You Truncate A Table Using Entity Data Model?

Answer :

Unfortunately Entity Framework doesn’t include whatever clear-cut to deal with this. But we will nevertheless name a T-SQL announcement the usage of entity framework so as to nevertheless minimizes the builders paintings. We can name ExecuteStoreCommand() methond on ObjectContext as proven underneath.

Code:

using (var context = new MyTestDbEntities())

    context.ExecuteStoreCommand("TRUNCATE desk Dummy");

Question 4. How Do You Query In Entity Model When The Result Has A Join From From Different Database Other Than The Entity Model?

Answer :

E.G.: SELECT t1.C1, t2.C2 FROM table1 AS t1 JOIN table2 t2 ON t1.C1 = t2.C1
As the entity version doesn’t aid querying from any entity other than the entities defined in Entity Data Model, we must query aginst the statistics base the usage of ExecuteStoredQuery of the context.

Following code snippet suggests how to query whilst different databases are joined.

Code:

string question = "SELECT t1.C1, t2.C2 FROM table1 AS t1 JOIN table2 t2 ON t1.C1 = t2.C1";

the usage of (var context = new SampleEntities())

  ObjectResult records = context.ExecuteStoreQuery(question);

  foreach (DbDataRecord file in facts)

  

    //Do whatever you need

  

XML Tutorial
Question five. What Is Minimum Requirement For Entity Framework Applications To Run?

Answer :

The Entity Framework is a part of the .NET Framework so Entity Framework packages can run on any laptop on which the .NET Framework beginning with model 3.Five SP1 is established.

HTML 5 Interview Questions
Question 6. What Is Csdl?

Answer :

Conceptual schema definition language (CSDL) is an XML-primarily based language that describes the entities, relationships, and features that make up a conceptual version of a statistics-driven application. This conceptual model may be used by the Entity Framework or WCF Data Services.

The metadata this is defined with CSDL is utilized by the Entity Framework to map entities and relationships that are described in a conceptual model to a records supply.

Question 7. What Is Ssdl?

Answer :

Store schema definition language (SSDL) is an XML-based language that describes the garage version of an Entity Framework software.

In an Entity Framework utility, storage model metadata is loaded from a .Ssdl file (written in SSDL) into an example of the System.Data.Metadata.Edm.StoreItemCollection and is offered with the aid of the use of strategies inside the System.Data.Metadata.Edm.MetadataWorkspace elegance. The Entity Framework uses storage version metadata to translate queries against the conceptual version to save-specific commands.

HTML five Tutorial Framework7 Interview Questions
Question eight. What Is Msl?

Answer :

Mapping specification language (MSL) is an XML-primarily based language that describes the mapping among the conceptual model and garage version of an Entity Framework utility.

In an Entity Framework application, mapping metadata is loaded from an .Msl file (written in MSL) at construct time. The Entity Framework uses mapping metadata at runtime to translate queries towards the conceptual model to keep-unique instructions.

Question nine. What Is Entity Data Model?

Answer :

The Entity Data Model (EDM) is a fixed of principles that describe the structure of information, irrespective of its stored form. The EDM borrows from the Entity-Relationship Model defined by Peter Chen in 1976, but it also builds on the Entity-Relationship Model and extends its traditional uses.

The EDM addresses the challenges that rise up from having information saved in lots of bureaucracy. For example, don't forget a commercial enterprise that shops statistics in relational databases, textual content files, XML documents, spreadsheets, and reports.

This presents great challenges in records modeling, utility layout, and statistics get right of entry to. When designing a records-oriented utility, the venture is to write down green and maintainable code without sacrificing green facts get right of entry to, garage, and scalability.

When facts has a relational shape, statistics get right of entry to, garage, and scalability are very efficient, however writing efficient and maintainable code turns into more difficult. When records has an object structure, the change-offs are reversed: Writing green and maintainable code comes on the cost of green facts get entry to, garage, and scalability. Even if the right stability between these alternate-offs may be determined, new challenges get up when data is moved from one shape to some other. The Entity Data Model addresses those demanding situations through describing the shape of statistics in phrases of entities and relationships which might be impartial of any storage schema.

This makes the stored form of statistics inappropriate to utility design and development. And, due to the fact entities and relationships describe the shape of facts as it's miles used in an application (now not its saved form), they are able to evolve as an utility evolves.

Javascript Advanced Interview Questions
Question 10. Which Are The Key Concepts Of Entity Data Model?

Answer :

The Entity Data Model (EDM) uses 3 key principles to explain the structure of statistics: entity type, association type, and assets. These are the maximum essential principles in describing the structure of statistics in any implementation of the EDM.

1. Entity Type: The entity kind is the fundamental constructing block for describing the shape of data with the Entity Data Model. In a conceptual model, entity sorts are produced from residences and describe the shape of pinnacle-level concepts, such as a clients and orders in a commercial enterprise utility.

2. Association Type: An association kind (additionally known as an affiliation) is the fundamental building block for describing relationships in the Entity Data Model. In a conceptual version, an affiliation represents a dating between two entity kinds (which includes Customer and Order).

Three. Property: Entity sorts comprise houses that outline their shape and characteristics. For instance, a Customer entity type may additionally have residences such as CustomerId, Name, and Address.

Microsoft Entity Framework Tutorial
Question eleven. What Is .Edmx File And What It Contains?

Answer :

An .Edmx document is an XML file that defines a conceptual model, a storage version, and the mapping among those models. An .Edmx record also consists of facts this is used by the ADO.NET Entity Data Model Designer (Entity Designer) to render a model graphically.

Java collections framework Interview Questions
Question 12. How Can You Tell Ef To Have A Different Table Or Column Name Than That Defined For The Class?

Answer :

By convention, EF defines the table and column names based for your elegance and assets names.
You can use the [Table] and [Column] annotations to tell EF to apply different names.

XML Interview Questions
Question thirteen. How Do You Mark A Property As Required? For Example, For A Project, The Name Is A Required Field.

Answer :

You use the [Required] attribute to mark a property as required.

Framework7 Tutorial
Question 14. What Is Use Of Entitydatasource Control?

Answer :

The ADO.NET EntityDataSource manage helps information binding scenarios in Web applications that use the ADO.NET Entity Framework. Like the Entity Framework, the manage is to be had as a part of the .NET Framework three.Five, starting with SP1.

Like the other Web server records supply controls, the EntityDataSource manipulate manages create, study, update, and delete operations against a statistics supply on behalf of records-bound controls at the same web page. The EntityDataSource works with editable grids, paperwork with user-controlled sorting and filtering, dually bound drop-down listing controls, and grasp-element pages.

Question 15. What Is Model First Approach?

Answer :

A new Model First technique changed into supported in Visual Studio 2010, which became released together with the second one Entity Framework model (Entity Framework v4). In Model First technique the development starts offevolved from scratch. At first, the conceptual model is created with Entity Data Model Designer, entities and family members are added to the version, however mapping is not created.

After this Generate Database Wizard is used to generate garage (SSDL) and mapping (MSL) parts from the conceptual part of the version and store them to the edmx record. Then the wizard generates DDL script for growing database (tables and foreign keys)

If the version was modified, the Generate Database Wizard have to be used once more to keep the version and the database constant. In such case, the generated DDL script includes DROP statements for tables, corresponding to vintage SSDL from the .Edmx record, and CREATE statements for tables, corresponding to new SSDL, generated by using the wizard from the conceptual element. In Model First method developer have to not edit storage element or personalize mapping, because they may be re-generated every time while Generate Database Wizard is released.

Oracle Performance Tuning Interview Questions
Question 16. What Is Code First Approach?

Answer :

Code First allows you to outline your model the use of C# or VB.Net classes, optionally additional configuration can be done using attributes for your classes and properties or by way of the use of a Fluent API. Your model can be used to generate a database schema or to map to an current database.

Javascript Advanced Tutorial
Question 17. What Is Entity Sql?

Answer :

Entity SQL is a SQL-like storage-impartial language, designed to question and control rich item graphs of gadgets based totally at the Entity Data Model (EDM).

Windows Presentation Foundation(WPF) Interview Questions
Question 18. What Is Linq To Entities?

Answer :

LINQ to Entities gives Language-Integrated Query (LINQ) help for querying entities.

LINQ to Entities enables builders to write queries against the database using one of the supported .NET Framework programming languages inclusive of Visual Basic or Visual C#.

HTML five Interview Questions
Question 19. What Is Entityclient?

Answer :

System.Data.EntityClient is a garage-impartial ADO.NET data provider that carries training consisting of EntityConnection, EntityCommand, and EntityDataReader. Works with Entity SQL and connects to storage particular ADO.NET facts companies, which includes SqlClient.

Windows Presentation Foundation(WPF) Tutorial
Question 20. What Is Deferred Loading(lazy Loading)?

Answer :

When gadgets are again through a query, related objects are not loaded at the identical time.
Instead they may be loaded mechanically whilst the navigation property is accessed. Also known as “lazy loading,”

Windows Communication Foundation (WCF) Interview Questions
Question 21. What Is Eager Loading?

Answer :

The process of loading a specific set of related items together with the gadgets that have been explicitly asked in the query.

Question 22. What Is Complex Type?

Answer :

A .NET Framework magnificence that represents a complicated property as described in the conceptual version. Complex sorts allow scalar homes to be prepared within entities. Complex items are times of complex kinds.

Windows Communication Foundation (WCF) Tutorial
Question 23. What Is Conceptual Model?

Answer :

An implementation of the Entity Data Model (EDM), unique to the Entity Framework, which represents an summary specification for the records systems that define an entity-courting representation of information inside the domain of an software.

Microsoft Foundation Class Library (MFC) Interview Questions
Question 24. What Is Use Of Entity Container?

Answer :

Specifies entity sets and affiliation units a good way to be applied in a certain namespace.

Framework7 Interview Questions
Question 25. What Is Explicit Loading?

Answer :

When objects are returned by using a query, related items aren't loaded at the same time. By default, they're no longer loaded till explicitly asked the usage of the Load method on a navigation property.

Microsoft Foundation Class Library (MFC) Tutorial
Question 26. What Do You Mean By Navigation Property?

Answer :

A belongings of an entity type that represents a courting to any other entity kind, as defined via an association. Navigation properties are used to go back associated items as an EntityCollection or an EntityReference, depending on the multiplicity at the other cease of the affiliation.

Net Micro Framework Interview Questions
Question 27. What Is Scalar Property?

Answer :

A belongings of an entity that maps to a unmarried subject in the storage model.

Javascript Advanced Interview Questions
Question 28. What Is Split Entity?

Answer :

An entity kind that is mapped to 2 separate kinds within the garage model.

Question 29. What Do You Mean By Table-in step with-hierarchy?

Answer :

A technique of modeling a kind hierarchy in a database that includes the attributes of all of the sorts in the hierarchy in a single table.

Question 30. What Do You Mean By Table-in line with-kind?

Answer :

A technique of modeling a type hierarchy in a database that makes use of a couple of tables with one-to-one relationships to version the various types.

Question 31. What Is Entity Graph In Entity Framework?

Answer :

Entity graph is nothing however to reveal the relationship between the entities. In EDMX there we've more than one tables and graph indicates the relation of entity as one to at least one, one to many or many to many relation.

Question 32. What Is Entity Framework Advantage?

Answer :

Advantage of the usage of entity framework is to generate the automatic code to engage with facts base. Its make your software in speedy pace of development.

Question 33. Differences Between Poco, Model First And Data First Approach?

Answer :

Database first:

1. Database create earlier than generation of code.
2. Automated code technology by using visible studio.
3. The usage of of T4 template generate the C# code.
4. No a whole lot control over the Code.

Code First Approach:

1. Database generated from POCO instructions.
2. No automatic code era.
3. Fully control over the code. You need to put in writing your personal C# Code.

Model First Approach:

1. Creation of Context and tables the use of the Designer tool.
2. T4 template will generate the C# code.
3. You have no longer complete control over the code or DB.
4. After introduction of tables, after you run application it generate database.

Java collections framework Interview Questions
Question 34. What Is Way Of Loading Data In Ef (entity Framework)?

Answer :

Lazy Loading: Process of loading the related objects till it's miles required.

Eager Loading:  Process of loading the associated objects is loaded robotically with its parent object.

Explicit Loading: Explicitly loading takes vicinity if you have disabled Lazy loading, and you still need to lazy loading. For this, we've to name the weight approach on the related entities.

Question 35. What Is Lazy Loading In Entity Framework?

Answer :

Lazy loading is the idea of loading the statistics only while we required. We can say it loading on demand. Suppose you've got a Department object there you have Employee object additionally and there may be 1 to many relation among Departments to Employee.

But when you fetch the information of department it might not load the Employee item however the tome while you are doing the foreach on Department item Employee object no longer loaded but once you will do the generation for Employee object than best the Employee item will load.

Question 36. How To Disable The Lazy Loading Framework?

Answer :

You can disable the lazy loading by way of
context.ContextOptions.LazyLoadingEnabled = fake;

Oracle Performance Tuning Interview Questions
Question 37. Can We Have Enum In Entity Framework?

Answer :

Yes you can create the Enum in entity framework.

Question 38. What Is Client Wins And Store Wins Mode In Entity Framework Concurrency?

Answer :

Client and Store wins are actions which we need to take when concurrency happens. In store Wins, facts are loaded into entity items and in Client wins facts will save from client aspect to database.

Question 39. Explain What Is Ado.Net Entity Framework?

Answer :

ADO.NET entity framework is an ORM (Object Relational Mapping) framework advanced by means of Microsoft. It is an extension of ADO.NET that provides an automatic mechanism to get entry to and store statistics in the database. With the assist of ADO.NET, database can be accessed without a whole lot required programming or code.

Question 40. Mention What Is The Key Advantage Of Using Entity Framework Or Ef?

Answer :

The most important benefit of using Entity Framework or EF is that it generates code automatically for the Model (Middle Layer), Mapping code and Data Access Layer. It reduces quite a few time in the course of the development manner.

Windows Presentation Foundation(WPF) Interview Questions
Question forty one. Mention In What All Scenarios Entity Framework Can Be Applicable?

Answer :

Entity Framework may be applicable in 3 situations

If you have existing database already or you need to construct your database first than other parts of the software
If your prime attention is your domain lessons after which create the database from your area training
If you want to layout your database schema at the visual clothier and create the instructions and database
Question forty two. Explain What Does .Edmx File Contains?

Answer :

.Edmx record is an XML report, which pronounces a conceptual model, a storage model and the mapping between these models.  This document additionally is composed the facts this is used by ADO.NET entity records model designer to render a model graphically. It consists of all the mapping information of ways object maps with SQL tables.  It is divided into three categories SSDL, CSDL, and MSL.

Windows Communication Foundation (WCF) Interview Questions
Question forty three. Mention What Is Csdl, Ssdl And Msl Sections In An Edmx File?

Answer :

CSDL: It stands for Conceptual Schema Definition Language, it's far the conceptual abstraction which is uncovered to the software

SSDL: It stands for Storage Schema Definition Language, it defines the mapping with our RDBMS facts structure

MSL: It stands for Mapping Schema Language, it connects the SSDL and CSDL

Question forty four. How Can You Enhance The Performance Of Entity Framework?

Answer :

To beautify the performance of Entity Framework, you need to comply with the following steps

Try to avoid to place all of the DB gadgets into one unmarried entity version
Disable change tracking for entity if not wanted
Reduce reaction time for the first request with the aid of the use of pre-generating Views
If no longer required attempt to keep away from fetching all the fields
For facts manipulation select appropriate collection
Wherever wanted use compiled query
Avoid the usage of Views and Contains
While binding records to grid or paging, retrieve most effective required no of statistics
Debug and Optimize LINQ question
Question forty five. Explain Why T4 Entity Is Important In Entity Framework?

Answer :

T4 entity is important in Entity framework as it is the heart of entity framework code era.  It reads the EDMX XML file and generate C# in the back of code.

Question forty six. Explain How You Can Load Related Entities In Ef (entity Framework)?

Answer :

You can load associated entities or records in EF in three ways

Eager Loading
Lazy Loading
Explicit Loading
Question 47. Mention What Is Code First Approach And Model First Approach In Entity Framework?

Answer :

In Entity Framework,

Model First Approach: In this method we create entities, relationships at once on the design surface of EDMX.

Code Approach: For code technique we avoid running with the visual fashion designer or entity framework.

Question forty eight. Explain Lazy Loading, Eager Loading, And Explicit Loading?

Answer :

Lazy Loading: It is a manner to put off the loading of related items till it is required.

Eager Loading: It takes place when you question for an item and all of the related gadgets are also returned. In keen loading, associated objects are loaded automatically with its determine object

Explicit Loading: Explicitly loading takes region when you have disabled Lazy loading, and you continue to need to lazy loading. For this, we've to call the load method on the associated entities.

Question forty nine. Mention What Are The Various Methods Provided By The Dataset Object To Generate Xml?

Answer :

To generate XML numerous DataSet item include

ReadXml () : It reads XML file into DataSet item

GetXml () : It returns string consisting an XML record

Write Xml () : It writes an XML statistics to disk

Question 50. Mention What Is The Difference Between Ado.Net And Classic Ado?

Answer :

In NET, we've got data-set while ADO we've file-set In file-set we can best have one desk and to insert more than one table you need to do internal be a part of. While the dataset in ADO.NET will have a couple of tables In NET, all facts persist in XML while in conventional ADO the data persists in binary layout also.