data-access
How to insert an n:m-relationship with technical primary keys generated by a sequence?
Let\'s say I have two tables with several fields and in every table there is a primary key which is a technical id generated by a database sequence:[详细]
2022-12-29 00:07 分类:问答Best way to get a single value from a DataTable?
I have a number of static classes that contain tables like this: using System; using System.Data; using System.Globalization;[详细]
2022-12-27 09:27 分类:问答Overly accessible and incredibly resource hungry relationships between business objects. How can I fix this?
Firstly, This might seem like a long question. I don\'t think it is... The code is just an overview of what I\'m currently doing. It doesn\'t feel right, so I am looking for constructive criticism and[详细]
2022-12-26 00:24 分类:问答Recommend .NET data access layer/middle tier
I\'m currently creating an MVC application that will likely to expand to include a silverlight, wpf and possible windows phone all using the same data.[详细]
2022-12-24 10:42 分类:问答How do I create a generic overall .NET programming structure for my company?
I\'m in a company that writes their own business data applications when there\'s no good off the shelf alternative. Most often it\'s[详细]
2022-12-22 07:42 分类:问答WCF SOA: CRUD Data Access Service...why bother (or is our design wrong)?
We have a Data Access service in our SOA WCF system. This service is responsible for doing CRUD (create, update, delete) operations on \"system wide\" database tables, and is also the source of this d[详细]
2022-12-22 03:13 分类:问答Entity Framework on a database without foreign keys
I\'m currently working with a large database (approx. 500 tables) all without any foreign keys define.[详细]
2022-12-19 13:11 分类:问答What is a good approach for a Data Access Layer?
Our software is a customized Human Resource Management System (HRMS) using ASP.NET with Oracle as the database and now we are actually moving to make it a product that supports multiple tenants with t[详细]
2022-12-17 22:42 分类:问答Oracle.Dataaccess error ORA-06502: PL/SQL: numeric or value error: character string buffer too small
I am invoking a stored proc from .NET app. The proc returns an out parameter of type Varchar2. To fet[详细]
2022-12-17 17:20 分类:问答SQL Compact allow only one WCF Client
I write a little Chat Application. To save some infos like Username and Password I store the Data in an SQL-Compact 3.5 SP1 Database.[详细]
2022-12-16 06:50 分类:问答