localhost

Adhoc testing of .NET RIA Services

ASP.NET Blogs — Thu, 22 Oct 2009 00:00:00 GMT

Server and Port: here ASP . NET Web Dev Server. ClientBin directory ... dataservice.axd – you can find the registration of the handler in web.config... Read More......(read more)

Adhoc testing of .NET RIA Services

DotNetSlackers Latest ASP.NET News in Category SQL — Thu, 22 Oct 2009 00:00:00 GMT

Suddenly my Silverlight 3 application breaks during development process. Cause I have installed Visual Studio 2010 a few hours before, I was sure: must be something with 2010. After uninstall and reinstall SP1 everything worked fine, except .NET RIA services :-( So back to structured trouble shoothing. What is the first point, the database- SQL Profiler shows no requests. Second point is Entity model. Till now I do not know any point to interactive test a model. Next point is the RIA Service. But...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Data Tutorial 2 - Building our Master Page and Site Navigation Structure: ASP Alliance

ASP.NET Blogs — Thu, 22 Oct 2009 00:00:00 GMT

In this article, Scott examines how to build a master page and site navigation structure using ASP.NET 2.0 in a series of step-by-step demonstrations. Read More......(read more)

SQL SERVER Difference Between Candidate Keys and Primary Key

DotNetSlackers Latest ASP.NET News in Category SQL — Thu, 22 Oct 2009 00:00:00 GMT

IntroductionNot long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys.Let us first try to grasp the definition of [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

Data Enhancements in .NET 4 / Visual Studio 2010 Beta 2

ASP.NET Team Blogs — Wed, 21 Oct 2009 00:00:00 GMT

On Wednesday we are releasing .NET 4 / Visual Studio 2010 Beta 2 to the public and  it brings many cool enhancements to the ASP.NET data controls and Entity Framework. I’m going to drill into a few features of these data related features and you can read more about all the changes to ASP.NET 4 at: http://www.asp.net/learn/whitepapers/aspnet40/ . This contains a very detailed list of all the changes we have made in ASP.NET. Here are a couple of my favorite “data” related features: 1) The Entity Framework now supports the ability to the ability to pluralize entity sets and singularize entities. This means when I refer the table the table will be called “Products” but the actual class that I work on in my application is a “Product”. This feels...(read more)

How to use InsertQuery property ? in ASP.NET

ASP.NET Blogs — Wed, 21 Oct 2009 00:00:00 GMT

I know how to use the AccessDataSource1.InsertCommand ="Insert into tbl_1(Thing, Color) VALUES (" &tbx1.text &"," &tbx2.text &");" Read More......(read more)

SQL SERVER Introduction to Business Intelligence Important Terms & Definitions

DotNetSlackers Latest ASP.NET News in Category SQL — Wed, 21 Oct 2009 00:00:00 GMT

What is Business IntelligenceBusiness intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for improved decision making. To put it simply, BI is an umbrella term that refers to [...]...

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

The Microsoft Ajax Library and Visual Studio Beta 2

ASP.NET Team Blogs — Wed, 21 Oct 2009 00:00:00 GMT

Visual Studio 2010 Beta 2 was released this week and one of the first things that I hope you notice is that it no longer contains the latest version of ASP.NET AJAX. What happened? Where did AJAX go? Just like Sting and The Police , just like Phil Collins and Genesis , just like Greg Page and the Wiggles , AJAX has gone out of band! We are starting a solo career. A Name Change First things first. In previous releases, our Ajax framework was named ASP.NET AJAX . We now have changed the name of the framework to the Microsoft Ajax Library . There are two reasons behind this name change. First, the members of the Ajax team got tired of explaining to everyone that our Ajax framework is not tied to the server-side ASP.NET framework. You can use the...(read more)

The Minutes On 9 - Channel 9 Video Interviews with the ASP.NET 4 Team

ASP.NET Team Blogs — Wed, 21 Oct 2009 00:00:00 GMT

Who loves you? Not only is Visual Studio 2010 Beta 2 now available for everyone to download (not just subscribers) but I've got 11 short video interviews with the ASP.NET 4 team up on Channel 9. I was up in Redmond just last week and made sure to stop by the offices of as many ASP.NET developers and program managers as I could. I chatted with a few faces you may recognize and a few you may not. All of them are working hard to make ASP.NET 4 cool. I'm still working on my video techniques, and I used two different HD cameras to film these videos. Your feedback (negative AND positive) is always appreciated. This series of videos is called Hanselminutes on 9 and you can get to all of these (and many more) using the Channel 9 Tag " hanselminuteson9...(read more)

Using SqlBulkCopy To Perform Efficient Bulk SQL Operations

DotNetSlackers Latest ASP.NET News in Category SQL — Wed, 21 Oct 2009 00:00:00 GMT

Over the years I've worked on a number of projects that have shared a common requirement - the ability for users to quickly import large amounts of data into a back end SQL Server database. One such project was a web application used by teachers and other staff members. The software was initially purchased for just two schools in the district, but was soon expanded to encompass other schools. Every few months one or two new schools were brought into the fold; every time a new school was added an administrative user would have to create accounts for the new teachers and staff members so that they could sign into the site. Initially, the application offered a web page for the administrator to create new user accounts one at a time, but this interface quickly became tedious and impractical once larger schools with upwards of 100 users were brought online.

To allow school administrators to quickly import new users we created a web page from which a user could upload an Excel spreadsheet that contained the one row for every new user; the columns in the spreadsheet mapped to table columns in the database. After uploading this spreadsheet, the application would walk through each row and insert a record into the table. Through this mechanism an administrator could create the 100+ user accounts by first building an Excel spreadsheet (something many of the schools already had on file) and then upload that spreadsheet. This technique may sound familiar - in Importing an Excel Spreadsheet Using Typed DataSets and TableAdapters, author Nannette Thacker walked through building such an interface.

While the described approach works well when importing hundreds of records, it starts to seriously slow down when importing thousands or tens of thousands of records. The slowdown is due to the fact that each imported record sends its own INSERT statement to the database. This results in a lot of "chatter" between the web server and the database server. If you are importing data to Microsoft SQL Server the good news is that this process can be dramatically sped up using ADO.NET's SqlBulkCopy class. In my testing, importing 10,000 records using the one INSERT statement per import record took more than three seconds to complete; using SqlBulkCopy took a fraction of a second.

This article look at how to use the SqlBulkCopy class to efficiently execute bulk operations against Microsoft SQL Server. Read on to learn more!
Read More >

Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.

localhost

Adhoc testing of .<B>NET</B> RIA Services

Adhoc testing of .NET RIA Services

Data Tutorial 2 - Building our Master Page and Site Navigation Structure: ASP Alliance

SQL SERVER Difference Between Candidate Keys and Primary Key

Data Enhancements in .NET 4 / Visual Studio 2010 Beta 2

How to use InsertQuery property ? in <B>ASP</B>.<B>NET</B>

SQL SERVER Introduction to Business Intelligence Important Terms & Definitions

The Microsoft Ajax Library and Visual Studio Beta 2

The Minutes On 9 - Channel 9 Video Interviews with the ASP.NET 4 Team

Using SqlBulkCopy To Perform Efficient Bulk SQL Operations

localhost

Adhoc testing of .<B>NET</B> RIA Services

Adhoc testing of .NET RIA Services

Data Tutorial 2 - Building our Master Page and Site Navigation Structure: ASP Alliance

SQL SERVER Difference Between Candidate Keys and Primary Key

Data Enhancements in .NET 4 / Visual Studio 2010 Beta 2

How to use InsertQuery property ? in <B>ASP</B>.<B>NET</B>

SQL SERVER Introduction to Business Intelligence Important Terms &amp; Definitions

The Microsoft Ajax Library and Visual Studio Beta 2

The Minutes On 9 - Channel 9 Video Interviews with the ASP.NET 4 Team

Using SqlBulkCopy To Perform Efficient Bulk SQL Operations

SQL SERVER Introduction to Business Intelligence Important Terms & Definitions