Written by A fast way to get a list you can copy into a code file with all the fields in a table.
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = ‘tablename’
Posts in category Uncategorized
Eager Loading in Entity Framework
Entity Framework (EF) does not support lazy loading. You must explicitly load the comments advising the EF what to include.
Using ctx as new MyDataContext()
lvComments.DataSource = ctx.Entity.Include(“SomethingToInclude”).First().Comments
lvComments.Databind()
End Using
Or
Using ctx as new MyDataContext()
Dim MyListOfSomething as List(of ListOfSomething) = ctx.ListOfSomething
MyListOfSomething.SomethingToLoad.Load()
lvComments.DataSource = MyListOfSomething.Comments
lvComments.DataBind()
End Using
MS Build for ASP.NET Website
The problem: no .csproj file in websites
The solution: http://www.dotnetsizzler.com/post/Using-MS-Build-in-ASPNET-Website.aspx Add a proj file to the website, and set up the build to use it. http://en.csharp-online.net/MSBuild:_By_Example%E2%80%94Dealing_with_MSBuild_Errors
Get value asp:Textbox value using javascript
Here are a few ways to get the value of an asp textbox
- document.getElementById(‘<%=Test.ClientID%>’).value
- <%=txtMyTextBox.ClientID%>
- Response.Redirect(“Form2.aspx?name=” + txtName.Text + “&num=” + txtStNum.Text );
Quick way to convert a generic list to a CSV using String.Join
String.Join(“,”,Array.ConvertAll(list.ToArray(),element => element.ToString()));
Entity Framework – How to add new object
For entity framework, you should use ObjectContext.AddObject() instead of Linq to SQL DataContext.TableName.Add()
Entity Framwork Query Examples
var selectCustomer = from c in dbContext.Customer.Include(“Invoice.Product”) where c.Id == id select c
Use PRG pattern for data modification
Use PRG pattern for data modification
“PRG stands for Post-Redirect-Get to avoid the classic browser warning when refreshing a page after post. Whenever you make a POST request, once the request complets do a redirect so that a GET request is fired. In this way when the user refresh the page, the last GET request will be executed rather than the POST thereby avoiding unnecessary usability issue.”