.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Toolbox: Logging Web App Errors, Learning LINQ, and More

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

See how to log Web application errors for better health monitoring, what to read if you're thinking about LINQ, and which blog Scott recommends reading this month.

Scott Mitchell

MSDN Magazine April 2008

View Complete Post

More Related Resource Links

Toolbox: Easy LINQ Queries, Becoming A Better Developer, And Logging Help


This month Toolbox provides help with error logging, finds an app that helps you write LINQ queries, and explores the non-technical side of development.

Scott Mitchell

MSDN Magazine September 2008

Toolbox: Synchronize Data, Review Runtime Errors, and More


This month we bring you products that let you synchronize data, correct runtime errors, and more.

Scott Mitchell

MSDN Magazine August 2006

SQL generated by LINQ for logging

Hi all. Plz help.I have this query and its result implements IEnumerable. RoutesEntities routesModel = new RoutesEntities(); LocalesEntities localesModel = new LocalesEntities(); var routesQuery = from rs in routesModel.Routes.ToList() join ls in localesModel.Locales.ToList() on rs.LocaleID equals ls.LocaleID select new { LocaleID = rs.LocaleID, RouteName = rs.RouteName }; **Question** : How to get generated SQL from this query, or how to convert its type to ObjectQuery to use routesQuery.ToTraceString(). Is it possible?**Reason** : I want to log all SQL queries to DB, though I don't want to create new object for joined contexts (tables)**Important** : I can't use ObjectQuery initially because after all I use     ListView.DataSource = routesQuery;    ListView.DataBind() And it can cause an error of using to different contexts (DB tables) for one datasource.So what should I do get generated SQL query?Thanks in advance.

logging errors

I joined one project recently, I want to know which tables are used for logging errors that occured while running scheduled jobs? how ? help me

SSIS Package Logging of Errors to Sql Server


SSIS 2008 R2

I’m a relative newbie to SSIS but a long time developer / dba.  I have developed several  packages that I execute from stored procedures, via the cmdshell,  and I want to capture any error messages that come from the actual execution.  Ideally I would check a sql table for any error results.  I found  SSIS > Logging on the Menu bar and created a Sql Server log (in the same database as I am executing the sp from).  In the Configure SSIS Logs, I created the appropriate entry on the Providers and Logs tab and on the details tab I selected only the OnError check box.  All well and good.  After an execution I find the sysssislog table in the system tables.  What I did not expect to see was the Begin Execution / End Execution rows for the package just executed.  I only want errors to show up however I have not yet tested an error situation.

Entity Framework and SQLCE - Repeated Logging of data (quickly) causes failed to open errors

Hi all
I am using C# Visual Studio 2010 with EF 4.1. I am receiving some SCADA data that I would like to log to the database, all is well, until the data comes in quickly (not really that quickly)
I parse and massage the data, and then call a "logMessageToDB" function.
now if I call the function again before the last message has been logged, I get an error in my error handler
logging the message caused the following error -> The underlying provider failed on Open.
How can I log the data more quickly? why does it take so long to add a new record.
My function is below, please excuse the uglyness of it (I have just started with C#, there is a bit of a learning curve)

Playing with Linq grouping: GroupByMany?

One of its features is grouping. Many people understand grouping like it is defined in Sql. Linq is implementing grouping quite the same way. Let's discover this syntax and how to make consecutive groups easier.

LINQ : Implementing IN and NOT IN

I got tried of typing

var result = from s in source
where items.Contains(s)
select s;and so I implemented the IN and NOT IN methods as extension methods:

101 LINQ Samples Tutorials

101 LINQ Example with sample code snippets....This sample prints each element of an input integer array whose value is less than 5. The sample uses a query expression to create a new sequence of integers and then iterates over each element in the sequence, printing its value

Linq: how to share parameters between lambda expressions ?

When using Linq to objects, you will quickly feel the need to pass some parameters from a method to another but it's not so easy because each Linq method is not calling the following one. In a Linq sequence, each method is using the result computed by the previous one. So, local contexts are not visible from one method to another.
The compiler is using two technical different ways to let parameters go out of a method.

Linq to Sql CompiledQuery container

Ok now let's go. Here is just a little trick but with some interesting patterns that could be useful in some other contexts not connected to Linq to Sql.

When using Linq expressions, like with Linq to Sql, translating the expression into something else (sql for example) is taking time and resources. Sometimes it's negligible, sometimes not...

LINQ to SQL Paging using GridView in C# and ASP.NET 3.5

This tutorial will show you how we can extend the LINQ to SQL Class and create methods that will allow us to page data from a SQL database. C# version.

Learning Jquery: The Basics

First lets go over the basics of jquery coding. All jquery starts with a "$" no matter what! In all of your jquery documents ( which is just a javascript file) you need the following code in your document, this code is to load your functions if you do not add this code your jquery will be useless.

Learning C# and OOP, Classes

This is the second lesson in a miniseries designed to teach you how to write object-oriented programs using C#. This miniseries will describe and discuss the necessary and significant aspects of object-oriented programming (OOP) using C#.

What is Lambda Expressions In LINQ

A lambda expression is an anonymous function that can contain expressions and statements, and can be used to create delegates or expression tree types.

All lambda expressions use the lambda operator =>, which is read as "goes to". The left side of the lambda operator specifies the input parameters (if any) and the right side holds the expression or statement block. The lambda expression x => x * x is read "x goes to x times x." This expression can be assigned to a delegate type as follows:

How to create 3 tier application using LINQ

As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Building a LINQ Provider

Throughout this article, we will build a simple IQueryable provider similar to the LINQ to SQL provider demonstrating what is needed to build a custom provider that is capable of executing LINQ queries and performing create, update and delete operations.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend