Tag | ADO.NET Posts

I faced this problem while using NetTires which I highly recommend for anyone who wants to quickly generate a Data Access Layer using Microsoft Enterprise Library without having to do the grunt work and writing boilerplate Data Access Code. In my efforts to not digress from the Topic I am going to keep some other data access mechanisms that I've used in the past out of the scope of this post and just state that NetTires is a Decent enough Data Access Mechanism I am currently in love with and am using ...
Billy McCafferty, another geek from GeeksWithBlogs, wrote about a project called “ASP.NET ActionPack”. The project is intended to leverage the same code-generation capabilities as Ruby-on-Rails, and does fairly the same job (creating Admin screens for Create/Update/Delete CRUD tasks), should end providing fair degree of classes customizations too. It's hosted on CodePlex by the way. I din't like Ruby On Rails since I saw some sceencast on it 2 month ago, and I have some comment on the ...
Most of my private programming time lately has been invested in my PhotoAlbum's new version, in which I implement bug corrections and prio 1 improvements over the version I used during the last holidays in Asia. I will publish that version soon together with a list of improvements. One important feature (or so I thought) is the ability to import the content of an Excel file into the XML files I use in the PhotoAlbum system. I use an Excel file as main repository for all my pictures' information, ...
I have been reading several posts from folks I respect for their advancement of practices like TDD, Agile ,DDD, and so on. Their wisdom has helped give me a great toolset to build deep, maintainable code that is production-minded throughout now. This is contrasted to writing what amounted to 'demoware' as I tried to write maintainable code using RAD tools. Still, I think Agile-minded leaders need to bear in mind that the enemy is not Microsoft if their creed is in fact rooted in the pragmatism of ...
Dave Hayden has two good blog entries on this subject: One on Saving and Retrieving Images from SQL Server Using DAAB and ADO.NET 2.0, and the other on Saving and Displaying Photos in SQL Server using ASP.NET. The former details putting the images in your DB and getting ‘em out, while the latter shows you how to display them on your web page once you’ve retrieved them. As always for Dave Hayden, the results are top-notch (well, except for the fact that he uses in-line SQL, but nobody’s ...
Microsoft has released today the first CTP of the ADO.NET vNext with a preview build of the ADO.NET Entity Framework including samples and white papers. If you are running a 64-bit version of Windows XP or Windows Server 2003 this CTP might not work correctly. Also since this is a very early CTP install it in a virtual machine and don't mess up your production machine.Download ADO.NET vNext August 2006 CTP Cross-posted from The .NET Aficionado ...
Today Microsoft released ADO.NET vNext CTP. This can be downloaded from microsoft site. ADO.NET vNext CTP, August 2006ADO.NET vNext CTP (Community Technology Preview) Other documents related to ADO.NET vNext are The ADO.NET Entity Framework Overview (June 2006)The ADO.NET Entity Framework Overview ADO.NET Technical Preview - Entity Data Model (June 2006)The ADO.NET Entity Framework Overview Next Generation Data Access (June 2006)Next-Generation Data Access: Making the Conceptual Level Real ...
I have read about the Update Grams and DiffGrams and know that the ADO.NET datasets work based on these technologies. Recently I got another requirement to update database in bulk with out using stored procedure. I was under the impression that SPs are compiled and with Application Blocks used for Caching the Stored Procedure parameters, that is the fastest way to update. I decided to compare the DB updation using Application Blocks+SP Vs UpdateGrams. The statistics goes like this. I updated all ...
ASP.NET 2.0 has started picking up the momentum and alredy there are a large scale of companies using it for developing cutting edge web applications. While the features, enhancements have been very good, the decisive factor in web applications development is performance. ASP.NET 2.0 in general has a lot of performance enhancement feature starting from compilation model to ADO.NET 2.0 DataSets which is comparitively faster than its predecessor. Please check New DataSet Features in ADO.NET 2.0 for ...
September 10-13, 2006 Add the Most Anticipated VSLive! Sessions to Your New York Agenda Check out the top ten sessions at VSLive! New York. See which sessions your peers visited most on our conference Web site. Then, add these interesting topics to your “Must See” list for New York. The Early Bird Deadline of August 9 is right around the corner – lock in savings of $200 by using Priority Code TOP10. Register today to attend these top ten sessions and our full conference lineup September ...
Resume – Senior, Hands-On, .NET, C#, VB, ASP, XML, SQL, SharePoint, Crystal, Reporting Services Developer, Team Leader, Hard-Core Coder Rodney Vinyard, 29 Windermere Road, Montclair, NJ 07043 rodney.vinyard@gmail.com · Seeking North NJ/Manhattan .NET/SQL developer job. · Hands-on .NET, C#, VB, SQL, ASP, XML, XSLT, Reporting Services, Crystal. · 30 years of productive, software engineering experience. · Inventive, focused, hands-on software designer, engineer & coder. · Effective leader, writer ...
As a developer always we want to have the opportunity to write the codes properly, along with programming language specific words and keyword to be highlighted in to different colors. Also VS.NET developers enjoys an IDE features named “Intellisense”, where while wring codes, a list of probable class or object name appears in a list and can be inserted to the code segment, just by selecting the appropriate item from the list. This becomes EXTREMELY useful, when we have to use long class ...
This new release includes: ASMX guidance package A brand new guidance package related to Data Access Layers generation based on ADO.NET 2.0. Updates to the documentation and Reference Implementation Simpler installer which will install the guidance packages into Visual Studio automatically and more... Also this release works with GAT June 2006 CTP bits so it takes advantage of all the new GAT features detailed by Tom here. You can download from the project workspace. Enjoy Pablo ...
I may be late to look at these articles but better late than never. ASP.NET site has a nice list of tutorials on working with ADO.NET in ASP.NET 2.0. The list is Introduction Creating a Data Access Layer Creating a Business Logic Layer Master Pages and Site Navigation Basic Reporting Displaying Data With the ObjectDataSource Declarative Parameters Programmatically Setting the ObjectDataSource's Parameter Values Master/Detail Master/Detail Filtering With a DropDownList Master/Detail Filtering With ...
In the morning I went to “Incorporating Agile Development into Your Organization”, given by Peter Provost (http://www.peterprovost.org/) and Adam Riddlehoover (http://blogs.msdn.com/arid... This was an awesome lecture about the techniques you can use to introduce Agile concepts into your dev process, and the benefits you can expect to receive. They talked about things such as Pair Programming, Test Driven Development, Daily Standup meetings, customer involvement, etc. They ...
I work alone (unfortunately) for a mid-size firm and am involved in aggregating very diverse types of data to eliminate data silos such as accounting packages, miscellaneous access dbs and excel workbooks, and payroll packages. On top of that I am building a package to handle construction material's testing procedures/calculations. Being all alone forces me into being very interested in things that make my life easier. Most tools that I find in development are great, but the overhead associated with ...
This is my first blog post ever. D'Arcy convinced me that I should start a blog to talk about all the good times at Tech-Ed. So here we go. I'm headed down to Boston for Tech-Ed 2006 in a couple days. Should be a great time. This is my first Tech-Ed and I've been looking through the list of sessions available and it's pretty overwhelming. Out of the 700 or sessions available, I picked out about 50 or so I might be interested in attending. I'll probably only have time for about a dozen or so, so I ...

With the rumor that MS is releasing information about ADO.NET v.Next at TechEd, I plan to attend the ADO.NET meetup Jonathan Bruce is hosting on Tuesday. He has details on who is attending and since it is in my hotel, I can't complain about distance. Check out details here...

A few weeks ago, I linked to a list of What Great .NET Developers Should Know. I then came up with the idea of adding more of my own through my own experiences. I found this list to be helpful and not just random trivia and picking points out of the .NET class libraries. If anyone has more to add or to nitpick my list, please let me know... Updated 6/15/2006 See Questions BizTalk Developers Should Know as well for more questions Common Language Runtime Questions: Describe the inheritance differences ...
First presentation of the code camp was Daniel Carbajal on the newest May CTP of Orca, which includes the LinQ tools. LinQ is a new technology in Orca that sits as a layer on top of ADO.NET. Although you can still use ADO.NET in Orca, you also now have the ability to use LinQ exclusively and not touch ADO.NET again...ever..seriously. No more creating command objects or whatnot...its all done behind the scenes now. Some other very kewl features are xml write in the code file (no more wrapping it in ...
.NET Framework 2.0 includes a very low level trace facility for ADO.NET. Below are the basic steps to get tracing up and running. 1) Activate the tracing DLL. Framework 2.0 ships with AdoNetDiag.dll. This contains the ADO.NET tracing providers. To activate it, make the following registry entry (note the : in front of Path): 2) Register the ADO.NET tracing providers with WMI: 3) Setup tracing in the performance monitor: 3a) Create a new tracing log, name it whatever you like: 3b) On the general tab, ...
Roanoke Valley( Virginia) .NET User Group (RV.NUG) Meeting - Tomorrow - Thursday 5/4/06 - 6 pm Our group is growing every month - it's exciting! Tomorrow we have an INETA sponsored speaker - Sahil Malik presenting on ADO.NET - System.Transaction and distributed transactions. I've heard Sahil speak before and he can take a complex topic and break it apart so it's easy to understand. I'm looking forward to the presentation and hoping for a great turnout to welcome him. The summer months will bring ...
For a while I have been adding books to the library feed of this site one at a time. Here is a list of books that I currently keep on my “must have” bookshelf. I will update this periodically as new volumes are added and dropped. The Library link list will also stay syncronized. .NET 2.0 Visual Basic 2005: A Developer's Notebook ASP.NET 2.0: A Developer's Notebook Pro .NET 2.0 Windows Forms and Custom Controls Programming Microsoft ASP.NET 2.0 Core Reference Expert VB 2005 Business Objects, ...
And I'll be there! It's at the Watermark Country Club at 6:00 PM. It should be a very good meeting, with Sahil Malik speaking about ADO.NET and John Cripe (of NuSoft) talking about SQL Server 2005.If you're there, say hi. I'll be wearing a black NationalCityHomeLoans.com shirt.Technorati Tags: grdotnet | Sahil+Malik | ADO.NET ...
The other great post by Stephen Kaufman is this indeep 'Using SQLXML's at-identity with BizTalk' http://blogs.msdn.com/skauf... To me that's not only explain a way to do this thing, but also some inside information about SQL adapter. So that I know how to cmpare the implementation between using SQL adapter or a custom ADO.NET DAC to insert data to the SQL server ...
I'v made some questions for .NET geeks in a kind of MCP exam format which would be used at the Ordina booth at DevDays in Gent. They're really simple and everyone should have a good score on this mini exam. The purpose would have been to receive some Ordina gadgets if you passed it. But we decided to let the people play the hit-the-penguin game. Anyway .. here are the questions. You can answer by giving feedback. 1. You are writing a C# class for invoices adminstration. The class is inherited from ...
While teaching the ASP.NET 2.0 class (3201) in Baton Rouge, some questions about performance came up surrounding the new DataSource classes. I had actually meant to get all this testing done and posted by the middle of last week, so for those waiting to see these results, thanks very much for your patience. Altogether this became a fun little experiment, and more time consuming than I expected! I hope you find the results useful. To get started let's review the type of design-time fun we could have ...
There’s a good three part series on ADO.NET for the Object-Oriented Programmer on CodeProject. Part One details how to use ADO.NET as a thing data transport layer.Part Two improves upon the architecture used in Part One.Part Three shows how to serialize an object model ...

This installment of "The Baker's Dozen" presents a variety of tips and techniques to become productive with data handling techniques using ADO.NET 2.0 in Visual Studio 2005.

The Baker's Dozen: 13 Productivity Tips for ADO.NET 2.0

First of all, to be able to follow me up in this post, I think you should take a look at the first part of it before you continue reading. After the session of Dr. Ahmed Bahaa and a quick talk to him, I took a colleague from GNS Egypt and went with her to TOP IT session “Data Access in ASP.NET 2.0”, I looked at the guy speaking out there and returned to my previous belief that I should focus on other sessions than ASP.NET related, as I believed that I’ve seen enough, while there ...
Nullable types are exactly what data readers needed. Dealing with database nulls in previous versions of .NET was laborious, to say the least. However, just having the nullable types doesn’t solve all of your problems. The classes presented here go a long way towards that goal, though. From the introduction: .NET 2.0 introduced nullable types into the CLR which, for the first time, provided the ability for value types to be assigned a null value. However, ADO.NET 2.0 did not introduce any new ...
This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005 VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, ...
VistaDB 2.1 database for .NET has been releasedThis 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005 VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, ...
I've been following Vista DB for a little while now... basically they have built what is a small footprint database engine for cleanly embedding into an application... no MDAC incompatibilities (with Access/SQL Server), no external service that has to be installed/maintained/(another 24/7 virus target!), and runs in the same process space, so restarts are completely under your [application's] control. And I'd like to get my free copy ;-) VistaDB 2.1 database for .NET has been releasedThis 2.1 update ...
When companies such as BEA Systems, IBM, Oracle, SAP, Siebel Systems, IONA and Sybase comes together it is for an important reason. There are two main reasons for this, firstly Enterprise Java Beans initially didn’t come up with the goods, it didn’t really do the job it was advertised to do and it was clunky and clumsy. Secondly, because J2EE wasn’t as good as hoped it endured a few major revisions which has made it difficult (and expensive) to get JCP certified. Ok, so there is ...
Now that Visual Studio 2005 has been released for a month, more books are starting to hit the shelves, training classes are popping up, and a lot of articles are (still) being written. Below is a roadmap I have laid out to bring experienced Visual Basic .NET programmers up to date. Visual Basic 6er's will probably be okay too. Video Tutorials There are two video series available for free from the MSDN site. One covers Visual Basic and Windows Forms, the other ASP.NET. These are very basic and will ...
This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, ...
Just wanted to get an idea of how many people might use VistaDB and whether we should consider a database library in the RapidDB system for VistaDB? Let me know if you are using it already or are planning to use it in the future. Normally getting a database into RapidDB takes around 2 days of work, if the database system doesn't have significant exceptions to the norm (such as Oracle). Oh, and of course, I get a free copy of the system for developing the layer if I include the following press release ...
We've been investigating alternatives to MSDE for a recent project. Firebird was one of the alternatives we investigated. Today I saw in a blog post another possibility that we will consider: VistaDB for .NET VistaDB 2.1 database for .NET has been released This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to ...
This 2.1 update includes over 60 improvements, including new support for .NET 2.0 and Visual Studio 2005. VistaDB is a small-footprint, embedded SQL database alternative to Jet/Access, MSDE and SQL Server Express 2005 that enables developers to build .NET 1.1 and .NET 2.0 applications. Features SQL-92 support, small 500KB embedded footprint, free 2-User VistaDB Server for remote TCP/IP data access, royalty free distribution for both embedded and server, Copy 'n Go! deployment, managed ADO.NET Provider, ...
DLinq: Dlinq is the new ADO.NET for the Microsoft.NET Platform. DLinq allows you to execute the T-SQL queries using any .NET compatible programming language. Creating Mapping B/W Class and Database Tables: First thing you need to do is to create a class that maps to the database table. [Table (Name="Orders")] class Order { [Column (DbType="int not null",Id=true)] public int OrderID; [Column (DbType="nchar(50)")] public string CustomerID; [Column (DbType="nvarchar(60)")] public string ShipAddress; ...
Introduction Having recently attended a Test Driven Development workshop given by Scott Belware here in Montreal, I have been thinking on how I could apply the principles of TDD to the software I develop using the Nolics.NET O/R Mapper. TDD During Scott's workshop one of the main points was to use dependency injection and the strategy pattern to reduce coupling between components. The effect of doing so is to produce code that is much more testable. When developing classes using this plug-in model ...
In this article by Brian Noyes, learn to use the new features in Visual Studio 2005's DataSet Designer to create Typed DataSets and Adapters to provide a data access layer for your applications. He then shows how to extend the generated classes using with help from partial classes features. Some significant improvements have been made to the Visual Studio 2005 DataSet designer and the code that it generates that make it so you will rarely have to write your data access methods by hand of you choose ...
I have completed my first litmus test for my planned approach for our .NET 2.0 port: that it is possible for a .NET 1.1 WSE 2.0 Web services client to interact with a ASP.NET 2.0 WSE 2.0 Web service. I am happy to report that this has worked with no trouble; however, there is a gotcha here for those intending to support VS2003’s “Add Web Reference” feature: By default, ASP.NET 2.0 generates WSDL based on the SOAP 1.2 specification. VS2003 can only interpret the WSDL based on the ...
Time to study for the third leg of the triathelon - the XML Web Services and Server Components exam, C#.Net version (70-320). It has been two years since I took the last MCP exam, the web applications exam. I passed both the Windows and web MCP exams in 2003. Previously I used the Microsoft MCAD/MCSD Self Training Kit books, Visual C#.Net Core Reference, and ADO.Net Core Reference books, and daily took practice tests from Measureup.com as my study regimen. Measureup helped me alot last time. I have ...
I just read Bill Evjen's Learn ASP.NET Page, and it has a lot of good information you should check out. For some reason the comments on his page were not working. I couldn't get anything to post. So, here is a quick blast of items that I have stored in Yahoo! MyWeb related to .NET 2.0 Books There are not a lot of books out yet, but if you are familiar with ASP.NET already, check out ASP.NET 2.0: A Developer's Notebook. I leave it sitting on my Safari Bookshelf. They also publish a Visual Basic and ...
I guess anyone that has developed an n-tier application has come up against the question of how to communicate between the physical tiers of their application. Web Services are pretty popular, but if you don't need to expose your middle tier to other applications - if your middle tier is only ever going to be called by the presentation layer tier of your application do you really need all that standards overhead? I have used web services for some things and Binary remoting over http for others. Up ...
The other day while working on an ASP.Net website with some simple ADO.Net CRUD functionality, I was getting the most frustrating error."Line 1: Invalid syntax near 'spMyProcedureName'." But I ran the stored procedure in Query Analyzer, and it worked fine.Typically my response is to go to the web, but a search on the error message turned up only people with the same question - and no answers that worked for my situation.After much searching through code, and admittedly some yelling, it finally came ...
If you are reading this article without reading the first part, please check Data Concurrency in ADO.NET - Part I Version Number Approach In the version number approach, the record to be updated must have a column that contains a date-time stamp or version number. The date-time stamp or a version number is saved on the client when the record is read. This value is then made part of the update. One way to handle concurrency is to update only if value in the WHERE clause matches the value on the record. ...
I will be speaking at Tamp Code Camp on July 16th, this is a one day free developer event for developers by developers. if you are in the area I highly encourage you to attend. you can find out more about it here. http://www.tampacodecamp.com/ here is a list of the speakers Jeff Barnes Architect Evangelist - Microsoft Jeff Barnes, MCSD, MCDBA, MCSE – Microsoft Architect Evangelist for the Gulf States District. BizTalk 2004 for Developers Kevin Barnhill Web Architect - Wilson Miller [ www.naplesdot.net] ...