How to Select Data Record in LINQ from table

 

Below code snippets in C# get the all contacts data records from ABCWorks database

ABCWorksDataContext dataContext = new ABCWorksDataContext();
var query = from contact in dataContext.Contacts
select contact;

Here ABCWorksDataContext represent Database Entity model. Contacts represent collection of data records. dataContext.Contacts represent the Object of table Contact.
query is type of variant that represent contact collection.

Comments

Post a Comment

Popular posts from this blog

how to add meta tag elements dynamic in ASP.NET

protected void Page_Load(object sender, EventArgs e) { HtmlMeta objhtmlmeta=new HtmlMeta(); objhtmlmeta.Content = ""; objhtmlmeta.HttpEquiv = "refresh"; objhtmlmeta.Content = "10;URL=http://www.Xyzdfsdfsdfsdf.com/personal/1/searchResults.do?per=mrmls&la=EN&shcu=&cust(mtype)=res&xml=1&minprice=" + Session["MinPrice"] + "&maxprice=" + Session["MaxPrice"] + "&cu=USD&minsurface=&maxsurface=&minbedroom=" + Session["MinBedrooms"] + "&cust(garage)=&minbathroom=" + Session["MinBathrooms"] + "&minlsurface=&maxlsurface=&c_city=&cust1(d)=&cust(zipcode)=" + Session["Zip"] + "&cust(year-built)=" + Session["YearBuilt"] + "&cust(type)=&c_n_area=681&rpp=5&B1=Search"; Header.Controls.Add(objhtmlmeta); }
Read more

How Azure Load Balancer Works

Image
Azure Load Balancer Azure Load Balancer allows us to scale our applications and create highly available services. Azure load balancer allows you to distribute traffic to your backend virtual machines. An Azure load balancer provides high availability for your application. The Azure load balancer is a fully managed service itself. Azure Load Balancer includes a few key components. These components can be configured in your subscription through the Azure portal, Azure CLI, Azure PowerShell, Resource Manager Templates or appropriate alternatives. Following components play and important role in working of Azure Load Balancer. These are Frontend IP configuration The IP address of your Azure Load Balancer. It's the point of contact for clients. These IP addresses can be either: Public IP Address Private IP Address The nature of the IP address determines the type of load balancer created. Private IP address selection creates an internal load balancer. Public IP address selection crea...
Read more

Defensive Programming Approach - A developer must have this skill

Image
Defensive programming is a form of defensive design intended to ensure the continuing function of a piece of software under unforeseen circumstances. Defensive programming practices are often used where high availability, safety or security is needed — Wikipedia Defensive programming techniques are used especially when a piece of software could be misused mischievously or inadvertently to catastrophic effect. # Defensive programming is an approach to improve software and source code, in terms of: # General quality – reducing the number of software bugs and problems. # Making the source code comprehensible – the source code should be readable and understandable so it is approved in a code audit. # Making the software behave in a predictable manner despite unexpected inputs or user actions Key points in order to achieve a Defensive Programming approach.These are as follows. 1.Don’t trust developers 2.Never trust user input 3.Use database abstraction 4.Don’t ...
Read more