DotNetShoutout - Stories tagged with ADO.NET

ADO.NET

atom rss
5
Shouts
spam Shout it Mute it

Introduction to BLToolkit (Part I): ADO.NET Wrapper
published 775 days, 10 hours, 54 minutes ago posted by slo2olsslo2ols 778 days, 23 hours, 59 minutes ago
Monday, April 04, 2011 7:46:31 PM GMT Friday, April 01, 2011 6:41:29 AM GMT
Last year ORMeter site made ​​a lot of noise. Its authors have done what many asked in various forums. They compared the performance of majority popular ORM on .Net platform. As a result developer's opinions were divided. Someone said that tests are out of touch with reality, someone has found another argument for infinite holy wars, someone thought that the site just advertise own product, etc. But there was another result. The developers around the world found out about such ORM as BLToolkit thatin alm... (more)
category: How To | clicked: 22 | 1 comment | | source: osmirnov.net
tags: ADO.NET, BLToolkit, Database, ORM
3
Shouts
spam Shout it Mute it

Getting Last inserted Identity value in SQL server
posted by deliciousdotnetdeliciousdotnet 782 days, 2 hours, 51 minutes ago
Tuesday, March 29, 2011 3:49:44 AM GMT
In this article I would like to share my idea about getting Identity after a row was inserted in to the SQL Server 2005. After inserting a row into the database which has primary key feild, most of the time we need the identity, We have three approches based on our reqiurements and situations. SELECT @@IDENTITY SELECT SCOPE_IDENTITY() SELECT IDENT_CURRENT(‘TableName’) All of the abouve three will get the identity value but in different approches. The variable @@IDENTITY will return the ... (more)
category: Data | clicked: 0 | comment | | source: deliciousdotnet.blogspot.com
tags: SQL Server, ADO.NET, C#.NET, ASP.NET
9
Shouts
spam Shout it Mute it

ADO.NET Entity Framework Performance Tips - Wriju's Blog
published 792 days, 15 hours, 26 minutes ago posted by iftekharahmedamitiftekharahmedamit 793 days, 15 hours, 6 minutes ago
Friday, March 18, 2011 3:14:29 PM GMT Thursday, March 17, 2011 3:34:47 PM GMT
Over a period of time I have been working with ADO.NET Entity Framework and I am flattered with its amazing usability. I am a big fan of EF and especially with EF4 release a lot more avenues are open. I love to talk about this technology in any forum and given a chance I would love to work on any implementation and migration. While doing all of these stuffs I found one big question which always comes to our mind is performance and it is quite obvious that for any data access technology performance is a b... (more)
category: Architecture | clicked: 4 | comment | | source: blogs.msdn.com
tags: ADO.NET, Entity Framework, Performance
3
Shouts
spam Shout it Mute it

Deleting all data from the data base and Resetting Auto increment value
posted by deliciousdotnetdeliciousdotnet 796 days, 19 hours, 34 minutes ago
Monday, March 14, 2011 11:07:11 AM GMT
Hi., Here in this post i would like to explain., how to delete data form the data base table using a single query. and also resetting the auto increment property. that means it will set to stating value. By using " DELETE FROM (more)
category: Data | clicked: 0 | comment | | source: deliciousdotnet.blogspot.com
tags: SQL Server, ADO.NET, C#, ASP.NET
8
Shouts
spam Shout it Mute it

EF 4.1 Is Coming (DbContext API & Code First RTW) - ADO.NET team blog
published 803 days, 12 hours, 9 minutes ago posted by iftekharahmedamitiftekharahmedamit 804 days, 6 hours, 53 minutes ago
Monday, March 07, 2011 6:31:51 PM GMT Sunday, March 06, 2011 11:47:51 PM GMT
Our latest EF Feature Community Technology Preview (CTP5) has been out for a few months now. Since releasing CTP5 our team has been working hard on tidying up the API surface, implementing changes based on your feedback and getting the quality up to production ready standards. At the time CTP5 was released we also announced that we would be releasing a production ready go-live in Q1 of 2011 and we are on track to deliver on the commitment. .. (more)
category: Architecture | clicked: 2 | comment | | source: blogs.msdn.com
tags: ADO.NET, EF, Entity Framework, EF 4.1, Entity Framework 4.1
2
Shouts
spam Shout it Mute it

Changing database records in ADO.NET - Part 5
published 810 days, 23 hours, 56 minutes ago posted by dotnetfundadotnetfunda 811 days, 10 hours, 43 minutes ago
Monday, February 28, 2011 6:45:19 AM GMT Sunday, February 27, 2011 7:58:24 PM GMT
We will see overview of Changing database records. (more)
category: Web Dev | clicked: 0 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

Different Types of Join in SQL server
published 811 days, 20 hours, 1 minute ago posted by dotnetfundadotnetfunda 812 days, 9 hours, 15 minutes ago
Sunday, February 27, 2011 10:39:55 AM GMT Saturday, February 26, 2011 9:25:32 PM GMT
In this Article I m going to show different types of Join. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

Data binding in ADO.NET - Part 4
posted by dotnetfundadotnetfunda 813 days, 12 hours, 37 minutes ago
Friday, February 25, 2011 6:03:58 PM GMT
We will look into the overview of Data binding in ADO.NET. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

Working with datasets - ADO.NET Part 3
posted by dotnetfundadotnetfunda 813 days, 12 hours, 47 minutes ago
Friday, February 25, 2011 5:54:01 PM GMT
Overview of working with datasets in ADO.NET. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

Overview of ADO.NET Classes - Part 2
posted by dotnetfundadotnetfunda 814 days, 12 hours, 43 minutes ago
Thursday, February 24, 2011 5:57:47 PM GMT
We will see overview of ADO.NET Classes . This is the second part of the ADO.NET Series article. (more)
category: Web Dev | clicked: 0 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
4
Shouts
spam Shout it Mute it

What is the Difference between Truncate and Delete in SQL Server.
published 813 days, 7 hours, 46 minutes ago posted by deliciousdotnetdeliciousdotnet 814 days, 18 hours, 43 minutes ago
Friday, February 25, 2011 10:54:52 PM GMT Thursday, February 24, 2011 11:57:33 AM GMT
Hai., here I would like give you explain a small difference what i have found between these two. When we delete the data using delete command like DELETE (more)
category: Data | clicked: 0 | comment | | source: deliciousdotnet.blogspot.com
tags: SQL Server, ADO.NET, truncate, commands, Delete
2
Shouts
spam Shout it Mute it

Overview of ADO.NET - Part 1
posted by dotnetfundadotnetfunda 815 days, 22 hours ago
Wednesday, February 23, 2011 8:40:29 AM GMT
We will see overview of ADO.NET. This is the first part of the ADO.NET Series article. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

How to use ExecuteScalar() method
posted by dotnetfundadotnetfunda 837 days, 12 hours, 3 minutes ago
Tuesday, February 01, 2011 6:37:53 PM GMT
We can use ExecuteScalar() method, if we have to retrieve a single value from a database. It executes the query and returns the first column of the first row in the result set returned by the query. Additional rows and columns are simply discarded. It returns a maximum of 2033 characters. It is better to get the result of MAX,MIN,COUNT, etc using ExecuteScalar() method. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

Data Adapter
published 838 days, 12 hours, 33 minutes ago posted by dotnetfundadotnetfunda 839 days, 10 hours, 22 minutes ago
Monday, January 31, 2011 6:07:38 PM GMT Sunday, January 30, 2011 8:18:54 PM GMT
A Data Adapter is a bridge between the Data Source and the data set.Select,Insert,Update,Delete operations in the Data Source can be performed by data adapter. A Data Adapter contains a connection object and a command object. It manages data in a disconnected mode. And opens and closes connection automatically, when reading or writing to a database. (more)
category: Web Dev | clicked: 0 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

ADO.NET : Some internals uncovered Part 2
posted by abhi2434abhi2434 869 days, 13 hours, 3 minutes ago
Friday, December 31, 2010 5:37:35 PM GMT
For the last 2 days, I thought of unleashing few of the hidden facts of Data Storage. It is true, that introduction of .NET framework without introducing Generic in first place is one of the biggest mistakes. Because of Non-Generic data structure a large amount of data is been unnecessarily boxed and unboxed without any reason as such. After Generics was introduced  with .NET 2.0, most of these classes which made you do type conversions is either been totally depreciated or few of them rarely used as is ... (more)
category: Architecture | clicked: 0 | comment | | source: www.abhisheksur.com
tags: .NET, ADO.NET
3
Shouts
spam Shout it Mute it

Autocomplete With jQuery and ASP.NET
published 880 days, 12 hours, 21 minutes ago posted by http://prashantmx.myopenid.com/http://prashantmx.myopenid.com/ 880 days, 23 hours, 36 minutes ago
Monday, December 20, 2010 6:20:11 PM GMT Monday, December 20, 2010 7:04:57 AM GMT
Building auto-complete feature with jQuery is easy and you can build this in no time. It's your wish if you want to use ADO.NET or EF (LINQ) to get this done, it works great for all. The sample application I build is using both ADO.NET and EF. So let's begin up getting files under one hood. Use the below live links for jQuery auto-complete and CSS. You can also download these files and use them in your project, if you are planning to run your application offline. For this demonstration, I have downlo... (more)
category: Web Dev | clicked: 1 | comment | | source: midnightprogrammer.net
tags: ADO.NET, Auto Complete, jQuery, ASP.NET 4, Linq
4
Shouts
spam Shout it Mute it

When it Comes to Asp.Net: Get Excel Sheet Names In Asp.net
published 880 days, 12 hours, 21 minutes ago posted by ashishsarda99ashishsarda99 880 days, 23 hours, 49 minutes ago
Monday, December 20, 2010 6:20:11 PM GMT Monday, December 20, 2010 6:52:25 AM GMT
Share| In Previous article named Reading Excel File in Asp.net , we discussed about Uploading excel file with One sheet, where we assumed that we know the name of the sheet i.e. Reading from "Sheet1" of uploaded excel file.(Demo Code) In this article we will discuss to read data from excel file where are not sure about the number of Sheets present in Excel file and name of those excel sheet. This is very common requirement for developers who are playing with Excel Data. We will keep logic of Uploadin... (more)
category: Web Dev | clicked: 0 | comment | | source: aspdotnetmatters.blogspot.com
tags: Data Table, Excel Data, ADO.NET, Excel table, web development
3
Shouts
spam Shout it Mute it

ADO.NET - Some Internals Uncovered
published 880 days, 12 hours, 21 minutes ago posted by abhi2434abhi2434 882 days, 8 hours, 14 minutes ago
Monday, December 20, 2010 6:20:11 PM GMT Saturday, December 18, 2010 10:27:15 PM GMT
During the early phaze of your career, when you just have started learning about .NET technology, you might have came across the sentence "ADO.NET is a disconnected database architecture". Well, its true, but how? How can ADO is transformed to such an architecture which no other database architecture supports. Every other database programming supports only RecorsSet which you need to use to get Data from the database.  Did you ever thought of it ? If you don't, it is time to rethink of it now. In thi... (more)
category: Architecture | clicked: 0 | comment | | source: www.abhisheksur.com
tags: .NET, ADO.NET, C#, DataTable
2
Shouts
spam Shout it Mute it

Reading Excel File in Asp.net
posted by ashishsarda99ashishsarda99 892 days, 23 hours, 39 minutes ago
Wednesday, December 08, 2010 7:01:28 AM GMT
One of the very common requirement in asp.net is end user uploaded Excel file and in Code behind, we need to Read the uploaded Excel file and Make sense out of data, i.e. Reading Excel File in Asp.net (more)
category: Web Dev | clicked: 2 | comment | | source: aspdotnetmatters.blogspot.com
tags: ADO.NET Connection, Data Table, ADO.NET, grid View, web development, Excel, ASP.NET
6
Shouts
spam Shout it Mute it

How to Separate Self-Tracking Entities to Their Own Class Library - Gil Fink on .Net
published 894 days, 12 hours, 55 minutes ago posted by gilfgilf 895 days, 22 hours, 9 minutes ago
Monday, December 06, 2010 5:45:28 PM GMT Sunday, December 05, 2010 8:31:52 AM GMT
Last week I had a session in Teched Israel 2010 which included approaches for building N-Tier applications on top of Entity Framework 4 as the data access technology. During the session I showed an example of how to use the new Self-Tracking Entities (STE) feature. In this post I‘m going to show how easy it is to put the STE in a different class library as a jump start for for using this T4 Template in N-Tier scenarios. (more)
category: How To | clicked: 2 | comment | | source: blogs.microsoft.co.il
tags: ADO.NET, N-Tier, Entity Framework 4, Self Tracking Entities
Previous 1 2 3 4 Next