{"id":65652,"date":"2021-07-10T04:10:05","date_gmt":"2021-07-10T08:10:05","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/database-programming-in-net-ado-net-overview-misc-net\/"},"modified":"2021-07-10T04:10:05","modified_gmt":"2021-07-10T08:10:05","slug":"database-programming-in-net-ado-net-overview-misc-net","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=65652","title":{"rendered":"Database Programming in .Net: ADO.Net Overview #Misc .Net"},"content":{"rendered":"<h2>Overview of ADO.net<\/h2>\n<p>Purpose<\/p>\n<ul>\n<li>Components of ADO.net and their functions<\/li>\n<\/ul>\n<p>\nADO.net provides disconnected database access to make minimum resource (RAM,Page Table,Heap) use. Database connections are open as long as the connection is required. Afterwards, the connection is just closed. If connections are kept active and if new connections are used for new operations, the system resource will easily used up. Further, it can consume database licenses quickly.\n<\/p>\n<p>\nADO.net has two major entities. DataSet and Data Provider\n<\/p>\n<h2>Data Set<\/h2>\n<p>Data set is in-memory representation of data. After querying a database, you may keep your data in a DataSet. DataSet may contain 0, one or more tables. The tables in DataSet are termed as DataTables. DataTables have two concepts\/collections DataColumns, and DataRows. DataRows contain the data. DataSet also contains DataRelations collections that may be used to create relations among the DataTables in the DataSet. Additionally, DataSet contains ExtendedProperties collections to contain custom information about the DataSet<\/p>\n<h2>Data Provider<\/h2>\n<p>It is actually a collection of several components. Some data provider objects are: <\/p>\n<ul>\n<li> SQL Server Data Provider: To interact with MSSQL Server Databases<\/li>\n<li> OLE DB.Net data provider: May be used to interact with other databases.<\/li>\n<li> ODBC (.Net) Data provider<\/li>\n<li> Oracle Data Provider: For efficient interaction with Oracle Databases<\/li>\n<\/ul>\n<h2>Data Provider Components<\/h2>\n<ul>\n<li> Connection Object: To connect to the database. Objects: SqlConnection(for MS Sql Server), OleDbConnection(for wide range of databases), ODBC Connection(to connect through ODBC), OracleConnection(for oracle). The main property of Connection objects are the ConnectionString.<\/li>\n<li> Command Object: like SqlCommand, OleDbCommand. After creating a connection a command object may be used to query the database or to run a stored procedure. It has methods like ExecuteNonQuery(For Insert,Update,Delete), ExecuteScalar(to access a single value),ExecuteReader(returns ResultSet, may be kept in a DataReader object)<\/li>\n<li>DataReader Object: Like, SqlDataReader, OleDbDataReader, [ODBCDataReader,OracleDataReader]. It is a read-only, forward only, connected data stream. It uses the connection exclusively and tries to use minimum system resources[contain only one row in the RAM]<\/li>\n<li> DataAdapter Object: It is the object that provides disconnected data access in .Net. DataAdapter fills a DataSet or DataTable by using it&#8217;s Fill method. Unlike DataReader DataAdaptor can propagate the changes in DataSet\/DataTable to the database using it&#8217;s Update method. DataAdapter  contains queries(select,update,insert,delete) in four properties like SelectCommand, InsertCommand,DeleteCommand,UpdateCommand. When fill method is called the data returned by SelectCommand query are saved in DataSets\/DataTables. Remember Update is another method, that copies DataSet data to the Database.<\/li>\n<\/ul>\n<p> From: http:\/\/sitestree.com\/?p=3749<br \/> Categories:Misc .Net<br \/>Tags:<br \/> Post Data:2016-07-16 16:46:07<\/p>\n<p>\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\t(Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a><br \/>\n\t\tIn Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a><br \/>\n\t\t<a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a><br \/>\n\t\t8112223 Canada Inc.\/JustEtc: <a href='http:\/\/JustEtc.net' target='new' rel=\"noopener\">http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) <\/a><br \/>\n\t\tShop Online: <a href='https:\/\/www.ShopForSoul.com'> https:\/\/www.ShopForSoul.com\/<\/a><br \/>\n\t\tMedium: <a href='https:\/\/medium.com\/@SayedAhmedCanada' target='new' rel=\"noopener\"> https:\/\/medium.com\/@SayedAhmedCanada <\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview of ADO.net Purpose Components of ADO.net and their functions ADO.net provides disconnected database access to make minimum resource (RAM,Page Table,Heap) use. Database connections are open as long as the connection is required. Afterwards, the connection is just closed. If connections are kept active and if new connections are used for new operations, the system &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=65652\">Continue reading<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1917],"tags":[],"class_list":["post-65652","post","type-post","status-publish","format-standard","hentry","category-fromsitestree-com","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69922,"url":"http:\/\/bangla.sitestree.com\/?p=69922","url_meta":{"origin":65652,"position":0},"title":"Database Programming in .Net: ADO.Net Overview #18","author":"Author-Check- Article-or-Video","date":"August 22, 2021","format":false,"excerpt":"Overview of ADO.net Purpose Components of ADO.net and their functions ADO.net provides disconnected database access to make minimum resource (RAM,Page Table,Heap) use. Database connections are open as long as the connection is required. Afterwards, the connection is just closed. If connections are kept active and if new connections are used\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":65654,"url":"http:\/\/bangla.sitestree.com\/?p=65654","url_meta":{"origin":65652,"position":1},"title":"XML Related Classes in .Net #Misc .Net","author":"Author-Check- Article-or-Video","date":"July 10, 2021","format":false,"excerpt":"Brought from our old site (yes, very old short-note): http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=633&title=XML%20Related%20Clasees%20in%20.Net XML in ADO.net VB.NET C#.NET XML is the foundation of .NET. .NET internally represents data as XML and hence can provide inter-operability and interaction among applications written in different platforms and languages [.Net compatible]. XmlReader In .Net you can use\u2026","rel":"","context":"In &quot;C# - Misc&quot;","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69924,"url":"http:\/\/bangla.sitestree.com\/?p=69924","url_meta":{"origin":65652,"position":2},"title":"XML Related Clasees in .Net #18","author":"Author-Check- Article-or-Video","date":"August 22, 2021","format":false,"excerpt":"XML in ADO.net VB.NET C#.NETXML is the foundation of .NET. .NET internally represents data as XML and hence can provide interoperability and interaction among applications written in different platforms and languages[.Net compatible].XmlReader In .Net you can use XML with SqlCommand object. You first create a connection to the sql server\u2026","rel":"","context":"In &quot;C# - Misc&quot;","block_context":{"text":"C# - Misc","link":"http:\/\/bangla.sitestree.com\/?cat=1973"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69868,"url":"http:\/\/bangla.sitestree.com\/?p=69868","url_meta":{"origin":65652,"position":3},"title":"nHibernate &amp; ADO.net entity Framework #19","author":"Author-Check- Article-or-Video","date":"August 21, 2021","format":false,"excerpt":"nHibernate & ADO.net entity Framework The ADO.NET Entity Framework vs. NHibernate and Other ORMs From: http:\/\/sitestree.com\/?p=5104 Categories:19Tags: Post Data:2007-04-05 04:55:01 Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a> (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http:\/\/Training.SitesTree.com' target='new' rel=\"noopener\"> http:\/\/Training.SitesTree.com<\/a> In Bengali: <a href='http:\/\/Bangla.SaLearningSchool.com' target='new' rel=\"noopener\">http:\/\/Bangla.SaLearningSchool.com<\/a> <a href='http:\/\/SitesTree.com' target='new' rel=\"noopener\">http:\/\/SitesTree.com<\/a> 8112223 Canada\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":6461,"url":"http:\/\/bangla.sitestree.com\/?p=6461","url_meta":{"origin":65652,"position":4},"title":"ASP.NET \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 :[\u09aa\u09b0\u09cd\u09ac\u0983 \u09e7\u09ec]:: ASP.NET Web Forms \u09a6\u09bf\u09df\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09be\u09a8\u09c7\u0995\u09b6\u09a8","author":"Author-Check- Article-or-Video","date":"February 21, 2015","format":false,"excerpt":"ASP.NET \u099f\u09bf\u0989\u099f\u09cb\u09b0\u09bf\u09df\u09be\u09b2 :[\u09aa\u09b0\u09cd\u09ac\u0983 \u09e7\u09ec]:: ASP.NET Web Forms \u09a6\u09bf\u09df\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09be\u09a8\u09c7\u0995\u09b6\u09a8 \u09b2\u09c7\u0996\u0995\u0983 \u09ae\u09cb\u09b8\u09cd\u09a4\u09be\u09ab\u09bf\u099c\u09c1\u09b0 \u09ab\u09bf\u09b0\u09cb\u099c \u0964 \u09af\u09be\u0995 \u098f\u0987\u09ac\u09be\u09b0 \u0995\u09a8\u09cd\u099f\u09cd\u09b0\u09cb\u09b2\u09c7\u09b0 \u09b9\u09be\u09a4 \u09a5\u09c7\u0995\u09c7 \u098f\u0995\u099f\u09c1 \u09ac\u09be\u0981\u099a\u09b2\u09c7\u09a8 \u0964 \u098f\u0987 \u09aa\u09b0\u09cd\u09ac\u09c7 \u0986\u09ae\u09b0\u09be ASP.NET Web Forms \u09a6\u09bf\u09df\u09c7 \u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u0995\u09be\u09a8\u09c7\u0995\u09b6\u09a8 \u0995\u09b0\u09be \u09b6\u09bf\u0996\u09ac\u09cb \u0964 \u0986\u09b0 \u09a1\u09be\u099f\u09be \u0995\u09be\u09a8\u09c7\u0995\u09b6\u09a8\u09c7\u09b0 \u099c\u09a8\u09cd\u09af \u0986\u09ae\u09b0\u09be ADO.NET \u09ac\u09cd\u09af\u09ac\u09b9\u09be\u09b0 \u0995\u09b0\u09ac\u09cb \u0964 ADO.NET \u0995\u09bf? ADO.NET \u09a4\u09cb \u09ac\u09cd\u09af\u09ad\u09be\u09b0 \u0995\u09b0\u09ac\u09cb \u09a4\u09be\u09b9\u09b2\u09c7\u2026","rel":"","context":"In &quot;Root&quot;","block_context":{"text":"Root","link":"http:\/\/bangla.sitestree.com\/?cat=1"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70273,"url":"http:\/\/bangla.sitestree.com\/?p=70273","url_meta":{"origin":65652,"position":5},"title":"nHibernate &amp; ADO.net entity Framework #.Net Web Applications","author":"Author-Check- Article-or-Video","date":"August 31, 2021","format":false,"excerpt":"Brought from: http:\/\/salearningschool.com\/displayArticle.php?table=Articles&articleID=988&title=nHibernate%20&%20ADO.net%20entity%20Framework This was written long long back, hence, the resources linked are also pretty old. nHibernate & ADO.net entity Framework The ADO.NET Entity Framework vs. NHibernate and Other ORMs From: http:\/\/sitestree.com\/?p=3701 Categories:.Net Web ApplicationsTags: Post Data:2016-07-16 09:01:03 Shop Online: <a href='https:\/\/www.ShopForSoul.com\/' target='new' rel=\"noopener\">https:\/\/www.ShopForSoul.com\/<\/a> (Big Data, Cloud, Security, Machine\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/65652","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65652"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/65652\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65652"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65652"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65652"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}