I was thinking about this for a while now, some years back, I always used Integer fields as Primary key columns in my database tables, more recently I have switched to using Guid values (uuid datatype in Sql Server) for the same. This is not a new thing for most of us, we have weighed the options and have chosen one way or the other. In my mind, Integers work very well as a Primary …
13 articles Articles posted in ADO.Net
A broad look at Web Application Performance
So does your web application perform well? Is it responsive enough so that it increases the web user experience? It is a fact that user can relate only to what they see and what they click, that is the user interface (UI) and the experience with it (UX) largely depends on the performance of the overall application. But what is the complaint that we usually hear, “this page is slow”, “this grid takes for ever …
Microsoft answers some data related questions…
These were the questions that was nagging many developers, for example future of LINQ2Sql, now that we have Entity Framework (I have heard people talking about the difference in usage scenarios), Where did ADO.Net data services go? etc…. I found this very useful page answering these questions, here is the link -> go Added on 07/28/10 – Check out this article, talks about the past, present and future of data development technologies from Microsoft -> …
A Cold Case Solved !
We have several web user controls in one of our sites. These controls are all placed in a Controls sub directory. Many controls are created runtime and added to placeholders in the page. When we build this particular site (currently uses ASP.Net 3.5) we used to get this error message… The type or namespace name ‘Controls_XXXXX’ could not be found (are you missing a using directive or an assembly reference?) And design time Visual Studio …
Build a web site using ASP.Net MVC – Part 1
At last, I have decided to get my hands dirty with some real project using ASP.Net MVC. This will give me an opportunity to explore various features that are offered with ASP.Net MVC extension. There are lots of articles available to read about this online. I’ve been reading all these time and now its time to do something more than reading … How to prepare for development? Install .Net Framework 3.5 SP1 – If you …
Using LINQ to manipulate data in DataSet/DataTable
Have you tried a micro ORM for your data access? Click to read more… LINQ (Language Integrated Query) provides a very easy and fast way to manipulate data that is cached in a DataSet. In .Net applications, DataSet represents a disconnected cache of data. Your application typically needs to search, filter thru this data in order to display this data according to the need. DataView provides a very limited options when it comes to creating …
Inserting/Updating Rows in Sql Database – Avoid chatty interface
Its a good design practise to avoid chatty interfaces. This is not only true when we design our objects and interactions among objects, but also for your database interactions. For example if you have multiple rows to be updated to your table, its highly inefficient to fire your inserts one at a time to your database. If you are using a dataset, in ADO.net 1.1, data adapters update method prcessed each datarow one at a …
ADO.Net and Sybase ! Strange behavior !
This is what I see, may be there is something that I don’t see !I am using .Net v1.1, Sybase db ver 12.5 with Sybase ASE OleDb Provider Ver 2.70.When I create parameters for my command (CommandType is StoredProcedure), it expects me to create the params in the same order as specified within the stored procedure. I am creating the params using names and not by ordinal! There is no error thrown even when the …
Infragistics Net Advantage 2005 Vol 3 – Tips and Tricks – Part 1
1) For development, always install the complete product, dont try to copy the Infragistics assemblies script files manually to set up your dev machine. A proper install will make sure that the components are added to your VS.Net IDE toolbox. If your install fails to do this, there is a command line utilty provided (available from Infragistics Program Group) with the product that will add VS.Net toolbox tab.If you are upgrading Infragistics from an older …
Response.Redirect not working in server?
[ASP.Net] Have you ever had an instance where your Response.Redirect calls are not working when you moved your code to remote server (every thing worked well in your local machine), first thing you check is your Page’s SmartNavigation settings. If you have turned on your SmartNavigation (in v1.1) this might give problems with your Response.Redirect ( Server.Transfer will work ). As a work around, set your SmartNavigation to false, before calling Response.Redirect Page.SmartNavigation = false; …
Recent Comments