Tagged Questions

1
vote
0answers
63 views

How can I compare my linq-to-sql model to the actual database schema? [closed]

I have created a .dbml file in my project, which contains all of the tables I'd like to access using linq-to-sql. I have a large number of enums in this particular project, and I'm storing them all ...
1
vote
1answer
155 views

Sharing transaction or connection between multiple instance of the class

Guys you must be thinking why I have to do that ... I may be wrong but the I am designing a system It has following layers Data Access Layer (Handles sql transactions) Data Managers Presentation ...
0
votes
2answers
128 views

Stored procedure executing but not able to access data in asp.net

I have a stored procedure that executes perfectly in SQL Server. However I am not able to access the rows that are return by it in asp.net from Data Access Layer My DataAccessLayer code is as ...
0
votes
0answers
85 views

Is My Data Access Leaking Connections?

Folks I have an N-Tiered ASP.Net Web Forms application which uses Enterprise Library 5.0 for data persistence. Recently I have noticed my application has been spitting out the following error ...
3
votes
1answer
595 views

Designing Data Access Layer using C#, SQL Server

OK, as the title suggests I am designing a data access layer for a survey framework I am currently working on. We all are familiar with the layered architecture notion, we try to achieve separation ...
1
vote
2answers
118 views

Where to migrate data from SQL Server?

I'm working on an application which was previously developed with EF, SQL Server, C# and WinForms. For some reasons we need to remove SQL Server and use some and put data in some other container like ...
3
votes
2answers
103 views

How can I send a ref int value to sqlserver from ASPx page?

I have this Stored procedure that returns UserID: ALTER PROCEDURE dbo.GetUserID ( @TopicID int, @AskerID int ) AS SELECT @AskerID = Post.Pt_CreatedBy WHERE (Topic.Tp_ID = ...
0
votes
1answer
47 views

SQL, MVC and Hosted Internet Applications

I have got to create an internet web application, hosted by a 3rd party, everything managed data-centric, stored procedures on SQL Server. I assume I can use MVC still? (don't like asp.net/webforms) ...
0
votes
2answers
75 views

Does a concurrect exception happen to both user

if a user edits a data record and the same time another user edits the same record too and both save. 1.) Will the concurrency exception ALWAYS happen only for one user? Actually its logical that ...
0
votes
6answers
378 views

Best practices for database comunication layer for SQL Server and .NET

I have been asked to implement in a couple of hours a new ASP.NET application that has to access a SQL Server database. I am wondering what is the best (and quickest) method to access the database, a ...
0
votes
4answers
310 views

SQL Server Layer for both Delphi and C#

I really don't like the concept of opening my SQL server(s) to the internet - even if I can lock down the firewall. However I've always been working directly with databases. I'm building a system now ...
6
votes
3answers
364 views

Business Layer vs SQL Server

I have an application that does complex calculations for members. Each member can have multiple US states linked to their profile. Each state has got different calculations for each course a member ...
3
votes
1answer
157 views

Can I paginate a query in Sql Server without using ROW_NUM () OVER (ORDER BY xxxxx)?

I'm working on a custom DAL and am now dealing with automatic result pagination. The DAL generates dynamic queries based on our models, like: Model.All() --> generates "select * from mytable" ...
3
votes
3answers
312 views

Which is the more efficient way to connect to a database?

Having a disagreement with a coworker, and I at this point, I don't care who is right, I'm more curious which is the better solution so that I can use it going forward. We have different ways to ...
0
votes
2answers
158 views

What kind of DAL to use with BizTalk 2010

I am thinking about replacing the business layer with BizTalk orchestrations exposed as WCF services as a standard architecture for many of our apps. Essentially ASP.NET and WinForms apps will call ...
3
votes
4answers
84 views

Putting a new web interface on an old fat-client database

My company has a fairly old fat client application written in Delphi. We are very interested in replacing it with a shiny new web application. This will make maintenance a breeze and many clients want ...
1
vote
2answers
1k views

C# Handle on SQL Server Message Output

When executing scripts in SQL Server Management Studio, messages are often generated that display in the message window. For example when running a backup of a database: 10 percent processed. ...
2
votes
1answer
342 views

What is the best .NET smart client SQL server database access solution?

My scenario: I have been given an antiquated, VB.NET (.NET 2.0 Framework) Smart Client that does direct communication to a SQL Server 2005 database. This application has been directly communicating ...
1
vote
2answers
119 views

Good data access methodology(ies) for planning tool?

I'm building/maintaining some planning tools, with the following characteristics: -data is loaded (read-only) from MsAccess/SQLServer into C# framework 3.5. Data is loaded into SQLServer/MsAccess ...
2
votes
2answers
247 views

Why to avoid dynamic SQL queries ? any suggestion to remove there bad part and to use these?

Can you please guide me why dynamic SQL is suggested to avoid ? Is there any way that I can keep on using dynamic SQL and avoid its bad things ?
1
vote
1answer
49 views

What tool to use to retrieve data from database stored procedure?

I have a stored procedure which will be used to populate a report in ASP.NET. My application mainly contains SELECT queries and it has to be developed quickly and be changeable in the future. I'd ...
0
votes
1answer
129 views

Fluent Nhibernate for ASP.Net/Winfoms Apps

Hi is there good tutorial about using Fluent Nhibernate in asp.net/winforms application ? I have read article about Fluent Nhibernate and it much better look on Nhibenate which from xml to mapping ...
0
votes
1answer
386 views

Quickest way to execute stored procedure in c# requiring least amount of code

I'm going to grab the results in a collection of entity. I don't just need the IDataReader object. So above should be answered considering that I've large no of parameters and many columns of data is ...
1
vote
3answers
538 views

Stored Procedures access when no access in a table

All, In SQL Server, can a stored procedure (beeing ran from a user) write to table where the user doesn't have access to write directly to the table? Rgds, MK
0
votes
4answers
337 views

Recommendations for implementing a complex schema in SQL Server using XML Type

My application has a complex schema for the domain entity. It is required use SQL Server 2008. Following are the complexities: Domain Entity is Hierarchical: The data structure is a tree; it is ...
1
vote
5answers
2k views

Creating Global Variable For Web Application - ASP.NET

i'm building my web application to connect with db. so far i have managed to deal with it, (although i didn't build BLL & DAL). i have a table which has column "id". i know there is a way to ...
0
votes
1answer
41 views

.Net - accessing multiple sql server groups / databases

My program (WCF service programed in C#) has to access multiple sql server groups and the databases within those groups (sql server). It looks like linq 2 sql definitely doesn't support this unless I ...
5
votes
7answers
583 views

Design Strategy: Query and Update data across 2 different databases

We have a requirement in which we need to query data across 2 different databases ( 1 in SQL Server and other in Oracle). Here are the scenarios which need to be implemented: Query: Get the data ...
3
votes
6answers
244 views

Are there existing data layers I can use for an application I'm building?

I'm writing a .NET application and the thought of implementing a data layer from scratch is icky to me. (By data layer I'm referring to the code that talks to the database, not the layer which ...
1
vote
8answers
433 views

What is better: sql string or stored procedures? [closed]

I have a data access layer which uses the Enterprise Library. Now I was wondering, which is better: Using stored procedures to create my SQL, or writing SQL strings within the data access classes?
0
votes
3answers
197 views

Better Data access components for windows desktop application

Which one can be the better one data access component for desktop application and why? 1.) For MS Access 2007: ADO, OLEDB, DAO 2.) For MSSQL 2005: ADO, OLEDB, DAO
0
votes
2answers
548 views

PHP ORM Solution for SqlServer

I am searching for DAL or ORM (Only ORM no MVC) Solution in PHP5 that can efficiently access SqlServer. I am new to SqlServer. and I need to code a part of ASP.net website in PHP5. I am currently ...
7
votes
5answers
2k views

.NET Object persistence options

I have a question that I just don't feel like I've found a satisfactory answer for, either that or I've not been looking in the right place. Our system was originally built using .NET 1.1 (however ...
2
votes
4answers
120 views

How can my application use both an MS Access database and a SQL Server database at the same time?

What strategies and techniques have you used to produce a data driven application that needs to access multiple diverse data sources? Specifically, Microsoft Access and SQL Server. Ideally, I'd like ...
2
votes
5answers
645 views

List of SQL Server errors that should be retried?

Is there a concise list of SQL Server stored procedure errors that make sense to automatically retry? Obviously, retrying a "login failed" error doesn't make sense, but retrying "timeout" does. I'm ...
2
votes
1answer
205 views

Handling database queries that fail due to a server failover

In an environment with a SQL Server failover cluster or mirror, how do you prefer to handle errors? It seems like there are two options: Fail the entire current client request, and let the user ...
0
votes
2answers
344 views

Data access patterns in SQLCLR

I'm using SQLCLR in my project and, for the record, I'm very pleased with it. However, I can't find any good sources of information for good data access patterns. Usually I do communication between ...
0
votes
3answers
457 views

Mapping class properties to generic columns in table .NET

I have have a SQL Server table which has generic names like Text1, Text2.. etc. The table was designed like this because the same structure is used for different projects. I have a class in .NET ...
3
votes
2answers
7k views

How do I determine if a column is in the primary key of its table? (SQL Server)

I am currently using... select Table_Name, Column_name, data_type, is_Nullable from information_Schema.Columns ...to determine information about columns in a given database for the purposes of ...
2
votes
3answers
973 views

IsolationLevel.RepeatableRead to prevent duplicates

I'm working on an application that is supposed to create products (like shipping insurance policies) when PayPal Instant Payment Notifications are received. Unfortunately, PayPal sometimes sends ...