ADO.NET :: SQL Generated By LINQ For Logging?
Sep 2, 2010
I have this query and its result implements IEnumerable.
[Code]....
**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?
View 6 Replies
Similar Messages:
Sep 2, 2010
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?
View 3 Replies
Feb 23, 2011
In a system I am creating, the customer requires all changes to data to be logged to a database table - with only changes being logged (i.e. if they only change 1 value on a form full of 10 fields, it'll only audit that one change). So essentially I need to be able to compare the old values to the new values.
This is of course easy - I've done this before, but it was rather messy - I would manually check each field in the database and compare it to the new one to decide if it should be audited. Is there any easier way, of perhaps automatically getting the changed column name/values? Or do I have to do it my 'messy' way?
Pretty much all of the changes to be logged are done using LINQ to SQL - so perhaps there's a way to compare the database table to the modified one, before calling submit changes?
View 5 Replies
Jul 6, 2010
I'm debugging some unexpected behavior and while tracing in to the .NET framework I see a bunch of stuff like this:
if (Logging.On) {
Logging.PrintInfo(Logging.Web, this, SR.GetString(SR.net_log_n_certs_after_filtering, filteredCerts.Count));
...
}
But (as expected by default) the execution steps right over these. Is there some way to turn on the logging? Or is that just something that the framework developers can do while making special builds of the framework?
View 1 Replies
Feb 3, 2011
I used the auto generated models to use my existing SQL server in a new website.in some forms I use rich text editor (CKEditor) so I added [ValidateInput(false)] to those post back actions. but that is a bad solution 'caus I have lost of other from items which needs validation. I came across a potential solution to that using [AllowHtml] which I need to add to the model properties. I tried that:
[Code]....
but that is an error "type or namespace couldn't be found.."any ideas about where the [AllowHtml] attribute should be?
View 10 Replies
Mar 12, 2010
In a database table, let's say I have a non-null field named "Description" with a default value of (''). If I drag this table onto the .dbml view in Visual Studio and click on the Description field, the properties will indicate that the Auto Generated Value is set to false, thus ignoring my default value of (''). This is fine, as long as I always explicitly set a value for Description when I perform an insert/update, but I ran into a problem today when I tried to do an insert without specifying a value for Description: Cannot insert NULL value into Description. The default value I set for the field was being ignored. To try and fix this error, I went back into the .dbml and set Auto Generated Value to true, and tried again - no error this time, but the data I tried to insert was ignored, and the default value, (''), was inserted instead. I do not want to explicitly set every field to a default value programmatically when I perform inserts. Is there any other way to resolve this issue other than making the fields nullable?
View 3 Replies
May 14, 2010
Technically I have the Data Annoations working with Linq to SQL classes - the problem is when validation
passes. When UpdateModel() tries to do its thing i can an error:The model of type 'MyProject.Models.Employee' could not be updated.What i did was i created a partial class for Employee (that is generated by linq to sql), then stuck a Meta Data class on top of it for the validation
[Code]....
And in my master page i include
<script type="text/javascript" src="/Scripts/jquery.validate.min.js"></script>
View 9 Replies
Jan 21, 2011
I have a table in the database for users with the columns FirstName, LastName, DateUpdated, UserUpdated. Now, I display the fields FirstName and LastName but the last to fields are just for internal record keeping. I don't want the user to see or be able to edit them. However, I do want the DateUpdated and UserUpdated field to be populated upon every insert and update. The user id is in the session and I just take the current date for the DateUpdated field.
My question is: How can I write the UserUpdated and DateUpdated fields without the user providing any values?I had a couple of ideas:
- Modify the DataContext class to automatically compute the values. Don't know if that's a good idea. Also, my changes will be overwritten when I re-generate the DataContext class.
- Create hidden fields that hold these vlaues. For instance: <asp:HiddenField ID="user_createdHiddenField" Value='<%# Eval("UserUpdated") %>' runat="server" />. But how do I actually assign a value to the field?
View 2 Replies
Sep 10, 2010
I'm using MS Enterprise Logging Application Block in an ASP.NET website.
For production launch, I will set up a log listener in one of these locations:
Sql Server database
Windows event log
Text files
Which has the least impact on performance?
NB - I can't switch to Log4Net or ELMAH at this point, so don't suggest that in your response.
View 3 Replies
Jun 3, 2010
I spent a day trying to make Ent Lib Logging work and log anything into database or event log. I have a web application and console application with the same Ent Lib config but only the console application is capable to log into the Event Log. I tried everything with permissions but I don't know what exactly I am doing — which services should have what. It does not work!
I read articles like this[URL] and I want to try to give the ASPNET account those permissions. I am using Windows 7 and I cannot find ASPNET user account. So where is it?
This is the config file which is automatically generated from Ent Lib utility and it works only on App.config, not on web.config:
[code]....
View 4 Replies
Jan 12, 2011
I think my subject line explains my problem in a nutshell.. I have a login page, I login like I should and everything works.I logout and when I type/paste the address to the page, in the address field, I still reach it just like if I was still logged in..The page I type in the address field is in a subfolder, only suppose to be able to be reached by logged in users and in this folder,ith it's own web.config-file:
<?xml version="1.0"?>
<configuration>
<system.web>
[code]...
View 9 Replies
Feb 24, 2011
Has anyone signed up to webspark ? I thought Id check it out, but whenever I try to log onto the site I get this error
Error 310 (net::ERR_TOO_MANY_REDIRECTS): There were too many redirects.
I can nevr get access to the site, has anyone else used webspark or had this problem ? If you have used webspark, is it any good ?
View 6 Replies
Jun 26, 2010
I'm writing an application in asp.net mvc.I have got presentation layer, controllers and viewModel layer, document layer ( document model [I use ravendb] and repositories) and a framework layer.Currently I'm wondering how to design logging. I have chosen Nlog + Ninject.Logging extensions.My question is what information should I write to log ? ( in debug / release )I know that all exceptions should be logged...
View 1 Replies
Jan 12, 2011
I was adding login and logout functionality to my ASP.NET website. While I am able to make the user log in by checking the username and password but on some pages should be available only if he is logged in. I am doing this by storing the user's value in a session
Secondly, I am using a Link button which changes to Logged in as example. So, how does the user log out?
View 3 Replies
Mar 9, 2011
I've been working on my personal website as of late, and even thought it's not a big problem because I'm the only one that sees it, it's annoying nonetheless.
Whenever I go to my login page, it all works fine. If I enter a bad username/password, it will just print a simple text message error(intended). But, if I login correctly, then instead of redirecting to the root of my website as I intend, it will instead create a new tab in firefox and from there it will be in / (which is correct). The problem is why does it create a new tab? I didn't even think forms were capable of such a thing:
My full login page is at [URL] The gist of it is:
<form method="post" target="/login">
Username: <input type="text" name="username" /> <br />
Password: <input type="password" name="password" /> <br />
<input type="submit" name="Submit" />
</form>
And my server side code is also very simple:
if(RouteID=="login"){
if(AuthenticationModule.Login(Form["username"],Form["password"],false)){
//logged in correctly
Response.Redirect("/"); //just go to the root of my site
}else{
Write("You fail at life");
}
}
View 1 Replies
May 11, 2010
What is the best logging pattern for asp.net mvc 2 using log4net? When should I initialize logger how should I access logger instance?
View 1 Replies
Jan 2, 2010
I am providing registered members of a website a weekly mailing which contains URLs to private pages on the website.
For usability purposes, I don't want the user to have to provide their credentials after they click on the URL.
I am using the ASP.NET Membership provider model.
Question
How can I implement this so that the user can be logged in by virtue of clicking a specialized URL link?
View 2 Replies
Nov 3, 2010
I wan't to connect to remote web page (that has login form) with HttpWebRequest. I am using this tutorial: http://www.byteblocks.com/page/How-to-submit-requests-to-web-sites-programatically-using-HttpWebRequest.aspx
,but I don't know where RequestAttributes class belongs to?!? Is there any better way to do this? The remote page is in ASP.NET, it's using Form authentication and when someone makes a request to default.aspx it redirects it to login page. I want to parse default.aspx page, but before I am able to do that, I need to pass credentials to login form via POST method in HttpWebRequest. Here is another example using POST method to pass parameters: http://www.worldofasp.net/tut/WebRequest/Working_with_HttpWebRequest_and_HttpWebResponse_in_ASPNET_114.aspx
but I don't understand why this does not work in ASP.NET remote page.
View 1 Replies
Jun 10, 2010
I've just starting looking at a site in place at work. They're using Elmah to log errors.It seems to be logging fine, but in the web interface, when I tell Elmah to show me 100 errors per page, it only shows the most recent 15.Then when I click on "Download Log" I only get shown 15 errors in the CSV.Anyone know how I can configure it to keep all the errors?Or can someone point me to some docs on how to do this?
View 2 Replies
Sep 15, 2010
I'm trying to create a setup in my ASP.NET website that allows me to enable/disable logging while the application is running at any point. I figure some of you have already done such a thing.
Here's the gist of what i'm trying to do:
if(ShouldBeLogging)
logger.Info("helloooooo there");
So how would you set up the boolean value ShouldBeLogging to be able to be turned on/off while the website is running without getting any serious performance drawbacks(seeing how its going to be accessed frequently)? I was thinking about putting something in the web.config, but wouldn't a change to that kick my user sessions if i wanted to turn it on?
View 3 Replies
Feb 3, 2011
I'm using the suggestion from this question: How to get ELMAH to work with ASP.NET MVC [HandleError] attribute?I used Aziz's second code sample.I ran the debugger to see what happens when an error occurs. The main function in the HandleErrorAttribute class is:
public override void OnException(ExceptionContext context)
{
base.OnException(context);
[code]...
View 3 Replies
May 3, 2010
I have a portal say 'portal.mysite.com'. I have another portal say 'login.mysite.com'. Could someone tell me how I could use the same login credentials to login into the subdomain?
View 1 Replies
Jul 28, 2010
How does one log in to a website programmatically?I just want to check that the provided username and password of a website is correct or not.
View 1 Replies
Oct 24, 2010
We are bulding an intranet for our company. Just to do things like log support calls, keep details of customers servers, computers etc.
What i want to do is have a table that will record changes for each page. If we have the servers table, if somebody updates the ipaddress i would like it to log the previous value, the date and time, the user that did it, the new value and what table and field they changed. Is this kind of thing possible? i would imagine i would need some code that would execute on the insert command that would programatically insert the details into the changes table.
View 1 Replies
Oct 21, 2010
As part of a master page template, several sites include a login control. Since the site is served over HTTP, I want the login control, once a successful login has been achieved, to resolve to a portal served over HTTPS.The closest I've seen to achieve this may be here, but I'm not entirely clear on its implementation.Can I get some feedback or suggestions on this?Of course, a simple "Login" link on all pages that point to a login paged served over HTTPS is another solution, but this is not what I'm looking for.
View 1 Replies
