DotNetShoutout - Stories tagged with ADO.NET

ADO.NET

atom rss
3
Shouts
spam Shout it Mute it

C#, Parallel deserialization of JSON stored in database « Daniel Wertheim
published 521 days, 8 hours, 10 minutes ago posted by sedanwersedanwer 524 days, 21 hours, 7 minutes ago
Sunday, January 15, 2012 11:54:38 AM GMT Wednesday, January 11, 2012 10:57:27 PM GMT
A while back ago I had to yield entities constructed by deserializing JSON stored in a database. The first solution just opened a simple single result, sequential reader against the database returning a one column result set containing JSON. This was just yield returned after deserialized to the desired entity. Trying to tweak this I turned to the task parallel library. The idea was to in a separate task, read from the datareade... (more)
category: Architecture | clicked: 34 | 1 comment | | source: daniel.wertheim.se
tags: JSON, ADO.NET, Task Parallel Library, DataReader, C#
7
Shouts
spam Shout it Mute it

SSIS #101 – Use expressions to pass parameters to ADO.NET Source
published 604 days, 8 hours, 13 minutes ago posted by dharadhara 611 days, 14 hours, 9 minutes ago
Monday, October 24, 2011 11:52:24 AM GMT Monday, October 17, 2011 5:55:26 AM GMT
I have several posts on how to pass parameters to 1) an OLE DB source in a data flow and 2) to an Execute SQL Task with OLE DB connection. For case 2), the key is to use the correct mark for the passed in parameter. Different connection types demand different... (more)
category: Data | clicked: 22 | 1 comment | | source: beyondrelational.com
tags: SQL Server, ADO.NET, SSIS
7
Shouts
spam Shout it Mute it

How to check for the existence of record into the database?
published 639 days, 1 hour, 31 minutes ago posted by dotnetfundadotnetfunda 646 days, 6 hours, 56 minutes ago
Monday, September 19, 2011 6:34:23 PM GMT Monday, September 12, 2011 1:08:49 PM GMT
In this article, we shall learn How to check for the existence of record into the database. (more)
category: Web Dev | clicked: 43 | 15 comments | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to use transactions in ADO.NET?
published 648 days, 10 hours, 35 minutes ago posted by dotnetfundadotnetfunda 650 days, 14 hours, 22 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 5:43:13 AM GMT
In this article, we shall learn how to use transactions in ADO.NET. (more)
category: Web Dev | clicked: 14 | 2 comments | | source: www.dotnetfunda.com
tags: ADO.NET
4
Shouts
spam Shout it Mute it

How to work with multiple result sets using SqlDataReader?
posted by dotnetfundadotnetfunda 653 days, 5 hours, 37 minutes ago
Monday, September 05, 2011 2:27:36 PM GMT
In this article, we shall learn how to work with multiple results set using and SqlDataReader. (more)
category: Web Dev | clicked: 2 | 1 comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to work with multiple results set using DataSet?
published 652 days, 13 hours, 39 minutes ago posted by dotnetfundadotnetfunda 655 days, 13 hours, 11 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 6:54:19 AM GMT
In this article, we shall learn how to work with multiple results set using DataSet. (more)
category: Web Dev | clicked: 6 | 1 comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to retrieve records from SqlDataReader?
posted by dotnetfundadotnetfunda 658 days, 5 hours, 35 minutes ago
Wednesday, August 31, 2011 2:30:03 PM GMT
In this article, we shall learn how to retrieve records from SqlDataReader. (more)
category: Web Dev | clicked: 0 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
4
Shouts
spam Shout it Mute it

How to bind data using SqlDataReader and where to use SqlDataReader?
published 660 days, 1 hour, 7 minutes ago posted by dotnetfundadotnetfunda 660 days, 6 hours, 45 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Monday, August 29, 2011 1:20:23 PM GMT
In this article, we shall learn how to bind data using SqlDataReader and where to use SqlDataReader. (more)
category: Web Dev | clicked: 8 | 1 comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to retrieve saved images from SQL Server database and show on the Page?
published 660 days, 23 hours, 19 minutes ago posted by dotnetfundadotnetfunda 663 days, 9 hours, 50 minutes ago
Sunday, August 28, 2011 8:46:16 PM GMT Friday, August 26, 2011 10:14:27 AM GMT
In this article, we shall learn how to retrieve the saved images from the SQL Server database and show them on the page. (more)
category: Web Dev | clicked: 10 | 1 comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to retrieve @@identity auto incremented value using OUTPUT paramter through stored procedure and C#
published 664 days, 16 hours, 10 minutes ago posted by dotnetfundadotnetfunda 665 days, 9 hours, 4 minutes ago
Thursday, August 25, 2011 3:55:04 AM GMT Wednesday, August 24, 2011 11:00:57 AM GMT
In this article, we will earn how to get the value from output parameter in C# which is returned by stored procedure; also we will see how to get the newly inserted record’s Incremented PK value using output parameter. In this article we used @@Identity sql server variable which tracks the incremented value on the table. (more)
category: Web Dev | clicked: 7 | 1 comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

How to save an Image into the database using Stored Procedure in ASP.NET?
published 664 days, 16 hours, 10 minutes ago posted by dotnetfundadotnetfunda 665 days, 9 hours, 6 minutes ago
Thursday, August 25, 2011 3:55:04 AM GMT Wednesday, August 24, 2011 10:58:53 AM GMT
In this article, we shall learn how to save an Image into the SQL Server database using Stored Procedure in ASP.NET. (more)
category: Web Dev | clicked: 10 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

How to update record into the database?
posted by dotnetfundadotnetfunda 670 days, 15 hours, 16 minutes ago
Friday, August 19, 2011 4:48:44 AM GMT
In this article, we shall learn how to update record into the SQL Server database. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
2
Shouts
spam Shout it Mute it

How to insert records into the database?
posted by dotnetfundadotnetfunda 673 days, 6 hours, 42 minutes ago
Tuesday, August 16, 2011 1:23:17 PM GMT
In this article, we shall learn how to insert records into the SQL Server database. (more)
category: Web Dev | clicked: 1 | comment | | source: www.dotnetfunda.com
tags: ADO.NET
3
Shouts
spam Shout it Mute it

C# and ADO.NET interview questions :- Can you distinguish between Dataset.clone() and Dataset.copy()?
posted by questpondquestpond 708 days, 6 hours, 42 minutes ago
Tuesday, July 12, 2011 1:22:59 PM GMT
The answer is the easy , people just get confused by the word clone and copy as they almost mean same things. (more)
category: Web Dev | clicked: 2 | comment | | source: questpond.blog.com
tags: ADO.NET, C# interview Questions, DataSet
3
Shouts
spam Shout it Mute it

Invalid Object Name with Entity framework -EFCodeFirstCTP5
posted by http://jalpesh.blogspot.com/http://jalpesh.blogspot.com/ 715 days, 11 hours, 44 minutes ago
Tuesday, July 05, 2011 8:21:01 AM GMT
Recently I was working on one sample application with EFCodeFirst with the existing database.After doing all the coding I have found a error “Invalid object name 'dbo.Customers'.”. Following was my code for data context using System; using System.Collections.Generic; using System.Data.Entity; using System.Linq; using System.Web; namespace CodeSimplified.Models { public class MyDataContext:DbContext { public DbSet (more)
category: Web Dev | clicked: 9 | 1 comment | | source: jalpesh.blogspot.com
tags: EFCodefirst, ADO.NET, entityframework
3
Shouts
spam Shout it Mute it

When it Comes to Asp.Net: Add Update Delete in Gridview Asp.net
published 779 days, 22 hours, 22 minutes ago posted by ashishsarda99ashishsarda99 781 days, 8 hours, 50 minutes ago
Sunday, May 01, 2011 9:43:20 PM GMT Saturday, April 30, 2011 11:14:28 AM GMT
Stock Market Ticker For Website - Yahoo Finance APIIn My Previous article Stock Market Ticker For Website ; we have seen how to USE YAHOO FINANCE URL, i.e. remote CSV file available for Downl... (more)
category: Web Dev | clicked: 0 | comment | | source: aspdotnetmatters.blogspot.com
tags: ADO.NET, Grid VIew. asp.net 3.5, C#.NET, Simple Gird Oprations, web development, ASP.NET
6
Shouts
spam Shout it Mute it

EF 4.1 Released - ADO.NET team blog
published 794 days, 7 hours, 59 minutes ago posted by KluggerKlugger 794 days, 23 hours, 43 minutes ago
Sunday, April 17, 2011 12:05:53 PM GMT Saturday, April 16, 2011 8:22:03 PM GMT
We are excited to announce the final Release to Web (RTW) of Microsoft ADO.NET Entity Framework 4.1 (EF 4.1). This is a fully supported, go-live release. What’s in EF 4.1? ADO.NET Entity Framework 4.1 introduces two new features: The DbContext API is a simplified abstraction over ObjectContext and a number of other types that were included in previous releases of the ADO.NET Entity Framework. The DbContext API surface is optimized for common tasks and coding patterns. DbContext can be used with Databa... (more)
category: Architecture | clicked: 15 | 1 comment | | source: blogs.msdn.com
tags: ADO.NET, Entity Framework, Code first, What's New, DbContext API
7
Shouts
spam Shout it Mute it

MVC + Code-First + Azure Part 2: Deployment - ADO.NET team blog
published 794 days, 7 hours, 59 minutes ago posted by iftekharahmedamitiftekharahmedamit 795 days, 33 minutes ago
Sunday, April 17, 2011 12:05:53 PM GMT Saturday, April 16, 2011 7:31:50 PM GMT
In the previous article, you learned how to create a basic MVC application using Code First. In the second and final section you will learn how to prepare and deploy your application to Windows Azure using Visual Studio. Deploying to Windows Azure Preparing Application Having tested our app locally, it is time to set up Azure to deploy our app. Although this process may seem long, all the steps except for deployment only have to be done once per application. First thing we must do before deploying is e... (more)
category: Architecture | clicked: 3 | comment | | source: blogs.msdn.com
tags: ADO.NET, Windows Azure, Code-first, Linq To SQL, Entity Framework, Code first, SQL Azure, DbContext API, MVC, Azure
6
Shouts
spam Shout it Mute it

Introduction to BLToolkit (Part III): The success story
published 797 days, 21 hours, 29 minutes ago posted by slo2olsslo2ols 799 days, 13 hours, 26 minutes ago
Wednesday, April 13, 2011 10:36:26 PM GMT Tuesday, April 12, 2011 6:38:33 AM GMT
We have already talked about that BLToolkit can serve as a substitute as ADO.NET, and LINQ to SQL. Time to talk about the unique capabilities of this ORM. In this post I will tell about how to expend BLToolkit and open secrets of its performance. (more)
category: How To | clicked: 16 | 1 comment | | source: osmirnov.net
tags: Expression Tree, ADO.NET, BLToolkit, Linq To SQL, Database, ORM
4
Shouts
spam Shout it Mute it

Introduction to BLToolkit (Part II): With LINQ to SQL's taste
published 801 days, 4 hours, 42 minutes ago posted by slo2olsslo2ols 803 days, 12 hours, 35 minutes ago
Sunday, April 10, 2011 3:23:14 PM GMT Friday, April 08, 2011 7:30:24 AM GMT
In the previous post we talked about what the BLToolkit was originally created as a high-level wrapper on the ADO.NET. Today we'll talk about why BLToolkit is an ORM and its similarity with LINQ to SQL. As I promised, we will carefully consider a support of Linq. (more)
category: How To | clicked: 12 | 1 comment | | source: osmirnov.net
tags: ADO.NET, BLToolkit, Linq To SQL, Database, ORM
Previous 1 2 3 4 Next