Search DaniWeb - data-access-layer

Data access Layer Design with C++ 14 Years Ago by Stefano Mtangoo … problem in UI thing. But I have problem with designing Data Access Layer. It will basically be a SQLite database backend (I may… 3 tier app, data access layer, business logic layer 15 Years Ago by skylancer … but I still confused how to implement it 1. In data access layer, could I return datareader? it's the better approach? some… (open and close), OleDbTransaction placed in business layer and I pass this as parameter to data access layer, is that good way? 3. if… Creating data access layer in java 20 Years Ago by pursottam tiwar dear all the programmer i m facing a difficulty in creating the concept of data access layer (DAL)concept in java ...as it is implemented in .net...if any one can help abt this plz send mail at [i][email]email removed by moderator[/email][/i] Re: Creating data access layer in java 20 Years Ago by jwenting …). There are several ways in which you can implement a data access layer. You could use EJB, JDO, or roll your own DAO… Re: Creating data access layer in java 20 Years Ago by freesoft_2000 Hi everyone, I did a similar project like this for some company. Your best bet is to try and build your own data access layer from scratch. Use your own concept and build it using the standard SDK. Please note that if you do this you are actually implementing your own industry standard Richard West Simple Data Access Layer against SQL Server 15 Years Ago by Ramy Mahrous If you need to execute SQL Statements\Stored Procedures\UDFs which return\don't return results, Here I've developed this class to be used in Data Access Layer. Suitable Design Pattern for C++ Daya Access Layer 15 Years Ago by rahim_rasimin … Pattern for C++ to create Data Access Layer. Objective is to have clear separate layer for Presentation Layer, Business Logic, and Data Access Layer. Sub Question: 1. In… C#, there was Dataset class to get data tabular records… Re: 3 tier app, data access layer, business logic layer 15 Years Ago by kvprajapati Learn the Entity Data Model. 1. [url]http://msdn.microsoft.com/en-us/library/aa697428%28VS.80%29.aspx[/url] 2. [url]http://msdn.microsoft.com/en-us/library/aa697427%28VS.80%29.aspx[/url] Re: 3 tier app, data access layer, business logic layer 15 Years Ago by skylancer [QUOTE=adatapost;1213573]Learn the Entity Data Model. 1. [url]http://msdn.microsoft.com/en-us/library/… Re: Data access Layer Design with C++ 14 Years Ago by Stefano Mtangoo Since no body have answered, I will pretend it to be unclear, let me get to the heart where I hit a wall. I know how to get stuffs from DB, and I know how to use them (In normal app) but have never done UI-BLL-DAL application and I was wondering how I can implement that. Main issue is what should BLL send and what should DAL return. Many articles… Re: 3 tier app, data access layer, business logic layer 15 Years Ago by kvprajapati Suggestions: 1. Do not return dataReader if performance of an application is not an issue. 2. Read and learn design patterns from these articles/blogs. 1. [url]http://www.codeproject.com/KB/cs/dalmethodcodegenerator.aspx[/url] 2. [url]http://www.codeproject.com/KB/architecture/ThreeTierThreeORM.aspx[/url] 3. [url]http://www.codeproject.com/KB/cs/… Re: 3 tier app, data access layer, business logic layer 15 Years Ago by skylancer [QUOTE=adatapost;1214464]Suggestions: 1. Do not return dataReader if performance of an application is not an issue. 2. Read and learn design patterns from these articles/blogs. 1. [url]http://www.codeproject.com/KB/cs/dalmethodcodegenerator.aspx[/url] 2. [url]http://www.codeproject.com/KB/architecture/ThreeTierThreeORM.aspx[/url] 3. [url]… Re: Creating data access layer in java 20 Years Ago by jwenting no, you're not implementing your own industry standard for the very reason that a standard is something that's generally accepted and used which your solution won't be ;) Unless you know very well what you're doing the best bet is to take an existing framework as the basis of your solution. JDO, Hibernate, EJB even (though I'd advise against … Re: Business logic layer 15 Years Ago by DdoubleD … For instance, by putting the data access layer into its own division, you …data access layer, that is where you want you OleDb, Sql Server, MySql, or other data access specific code to be contained. This data access layer… would be called upon by your business layer to manipulate data… Have I applied this 3-layer design pattern properly? 9 Years Ago by G_S …a simple dictionary application using the presentation-business logic-data layer pattern. I already have the design but am not… immediately instantiate a connection class. The third layer would be the data access layer. The actual SQL pocessing is being carried … Should the Entry class rather be in the data layer? If so, what should I punt in the … Need help in 3-tier coding in retrieving data to label 15 Years Ago by Clyw … it for me. thanks [B]I got the code for data access layer but im not sure if it's right:[/B] [code…; in the presentation layer (page load):[/B] [code] Dim UserController As New BusinessLogic.UserBLL Dim ds As System.Data.DataSet = UserController.getFeedbackQ… get data from datatable to datagridview 13 Years Ago by judithSampathwa …[r, 0].ToString(); } }[/CODE] in the business layer i have the below code. [CODE] public string GetEmpID… } } return benefit; } [/CODE] and in the data access layer i have the below code... [CODE] public DataTable GetEmpID(… Business logic layer 15 Years Ago by Mitja Bonca … me that I rather split my code into business logic layer and data access layer. And now I would like to ask someone if… Inserting data into a database 12 Years Ago by coder91 So I have a business object, data access layer and processes folders that hold code to select data using a stored procedue in SQL Management… and I know how to code it all to select data. However now I need to write code for it all… file's Ive to write. I have to use object data sources not SQLdatasources. Thanks How to create a simple entity without using Data Access Layer 12 Years Ago by cyberdaemon … protected form_load() { if(!isPOstBack) { getAllRecord(); //mymethod to call the data taht will be place on the gridview } } public void getAllRecord…query. i am not familiar with the linq and disconnected layer. i am just a beginner programmer that want to learn… Re: How to create a simple entity without using Data Access Layer 12 Years Ago by cyberdaemon Good day MattBerry, Thanks for the help buddy, You made my mind clear to the output that i want. i am just want to understand the entity framework in a connected layer. Once again buddy thanks for the help. Re: Data Tier help 19 Years Ago by cpopham …. The main thing the datatier should do is keep the data access seperate from the rest of the application. I most often… most often depends on what I wnt to do. The data access layer / module will also make your code easier to follow as… Re: Data Storage Question 12 Years Ago by slate … be tedious. The relatively hard part is to design the data access layer. Re: Centralized data in .NET? 17 Years Ago by f1 fan … the wheel :) the guys at Microsoft have developed a central data access layer and other useful stuff. It is in their applications blocks… Re: Have I applied this 3-layer design pattern properly? 9 Years Ago by DaveAmour … app such that it touches every layer from the UI, through the business logic, the data access and the database. This way it… Re: How to create a simple entity without using Data Access Layer 12 Years Ago by MattBerry Hi, I am a bit confused why you would want to effectively rewrite the EntityFramework? But you could do something like this: public class Contact { public int Id {get; set;} public string Name {get; set} } Note you don't need to add field names when doing it like this. Then in your form: ` List<Contact> … Re: Suitable Design Pattern for C++ Daya Access Layer 15 Years Ago by Ancient Dragon Use either [URL="http://www.google.com/search?source=ig&hl=en&rlz=1G1GGLQ_ENUS328&=&q=odbc+c%2B%2B+tutorial&aq=0&oq=odbc+c%2B%2B&aqi=g8"]ODBC[/URL] or [URL="http://www.google.com/search?hl=en&rlz=1G1GGLQ_ENUS328&q=ado+c%2B%2B+tutorial&aq=f&oq=&aqi="]ADO[/URL] in c++ programs. … Re: How To Compared Data Between Two Table With Same Database 9 Years Ago by djjeavons … another library in your solution, such as a Data Access Layer. Assuming that you are quite new to this …use these two pieces to connect and grab the data Dim connectionString As String = "Server=YourServer… connectionString) Dim table As New DataTable 'Fill the data table and bind to the GridView adapter.Fill(table… Re: Generics data type and interfaces 12 Years Ago by Ketsuekiame …. A good example of this is typically done at the data access layer, where you may wish to offer different providers to your… Creating Triggers Using Managed Code in SQL Server 2005 14 Years Ago by arjitmal …that is i am registering my assembly of (Data Access Layer) in SQL Server 2005 then due to its…do so (as Data Access Layer is dependent on Business Layer and Business Layer on Presentation Layer, and Presentation Layer is internally dependent…NET assemblies) SCENARIO 2 If i convert my data access layer to SQL Server project then it is impossible…