Question
a.
public USER GetUser(string userName)
{
DBNameDataContext myDB = NEW DBNameDataContext();
USER USER = myDB.Users.Single(u, u.UserName=>userName);
RETURN USER;
} ?
b.
public USER GetUser(string userName)
{
DBNameDataContext myDB = NEW DBNameDataContext();
USER USER = myDB.Users.One(u, u.UserName=>userName);
RETURN USER;
} ?
c.
public USER GetUser(string userName)
{
DBNameDataContext myDB = NEW DBNameDataContext();
USER USER = myDB.Users.findOne(u, u.UserName=>userName);
RETURN USER;
} ?
d.
All of the mentioned
Posted under SQL Server
{
DBNameDataContext myDB = NEW DBNameDataContext();
USER USER = myDB.Users.Single(u, u.UserName=>userName);
RETURN USER;
} ?
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following sample code is used to retrieve single row at a time?
Similar Questions
Discover Related MCQs
Q. Which of the following method is used to delete records in LINQ?
View solution
Q. Which of the following code in LINQ performs functionality similar to joins in SQL?
View solution
Q. Service broker was added to SQL Server ___________
View solution
Q. Point out the correct statement.
View solution
Q. There are _________ components of the Service broker in SQL Server.
View solution
Q. Which of the following service broker component defines the infrastructure used for exchanging messages between instances?
View solution
Q. Point out the wrong statement.
View solution
Q. Service Broker also provides security by preventing __________ access from networks and by message encryption.
View solution
Q. (SSBS) is a new architecture which allows you to write ____________ message based application.
View solution
Q. Which of the following change was introduced in SQL Server 2012 related to Service Broker?
View solution
Q. Which of the following is a Service Broker Related Dynamic Management View?
View solution
Q. Which of the utility is used for reporting the issue in Service Broker?
View solution
Q. ___________ is a set of technologies for copying and distributing data and database objects from one database to another.
View solution
Q. Point out the correct statement.
View solution
Q. How many types of replication is provided by SQL Server?
View solution
Q. Replication in SQL Server is used to overcome ________________
View solution
Q. Point out the wrong statement.
View solution
Q. Which of the following stored procedure provide replication support for AlwaysOn?
View solution
Q. How many types of replication components are present in SQL Server?
View solution
Q. Which of the following makes data available for replication?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond SQL Server? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
