Questions tagged [c#]

C# is a general-purpose, managed, garbage-collected, object-oriented programming language created by Microsoft.

Filter by
Sorted by
Tagged with
2
votes
1answer
25 views

Facing permission error while trying to execute a stored procedure published through CLR

I've created a stored procedure using SQL CLR c# stored procedure in Visual Studio 2017 and I've published it in MSSQL Server. Now I can see my stored procedure, but I face this error when I want to ...
1
vote
1answer
29 views

This failure occured while attempting to connect to the Principle server

One of our clients recently came to us with a problem he's facing while working with our application. The error in the log file is the next: System.Data.SqlClient.SqlException (0x80131904): Timeout ...
0
votes
2answers
22 views

How to group by linq based on input parameter?

I want to use group by in C#, and my result must be like this code in SQL: SELECT MAX(EffectiveDate) AS EffectiveDate,details.PersonnelBaseID FROM dbo.tkp_PersonnelDetails AS details where details....
0
votes
1answer
38 views

Use table in database like in excel [closed]

I'm writing a program for my client in C# Winform. And the client gave this excel sheet. Process I have a table that used to calculate BULK amount of alcohol by "DIP" and "SLIDE". In excel I need ...
0
votes
0answers
18 views

Configure MSLocalDB in a .NET config file

I have created a .NET Standard C# project and a SQL database in my LocalDB server (LocalDb)\MSSQLLocalDB. I have tried to configure the connection string in the project web configuration file but in ...
0
votes
0answers
10 views

C# foreach loop thru collection of unknown type [migrated]

I have a generic method that can be called with 2 different object types, TypeA or TypeB. TypeA and TypeB are essentially identical classes except in name only. I am trying to determine how to prevent ...
0
votes
1answer
34 views

How do you combine the input of three parameters into one?

I'm working on a query that will run via C# to SQL server. I'm trying to make the query flexible and provide parameters for all the inputs. Here is the query: SELECT Test_Matrix.tblTestMatrix....
0
votes
0answers
28 views

How can I figure out the root cause of “Out of range value for column” error in MySQL

I have a console app written with C# on the top of .Net Core 2.2 framework with EntityFrameworkCore as ORM. My application runs various tasks that run every 15 minutes. Each task calls an external API ...
0
votes
0answers
22 views

Database design for multilingual tags

I'm looking for a simple database design for tags, where the tag-label can be translated (multilingual). I'm currently looking at Toxi, which is a very simple and clean way of creating a tagging ...
2
votes
1answer
83 views

Bind dll in SQL Server

I have a little side project at my work. My task is to deploy some SQLCLR code into our dev-database (SQL Server 2017) to test it. If the tests are successfull, we want to develop triggers and ...
0
votes
1answer
48 views

Conditional insert vs UNIQUE constraint

https://stackoverflow.com/questions/4069718/postgres-insert-if-does-not-exist-already I would like to check if something exists before inserting it, what should I rely on? UNIQUE constraint or ...
0
votes
0answers
48 views

SSIS: Retrieving the value of a Sensitive Parameter in a Script within a Package Part

I've been reading Matt Masson's article on how to read the value of a sensitive parameter in a C# script. However the script in question is in a package part, which does not seem to be able to access ...
3
votes
1answer
279 views

Error publishing SQLCLR C# Function using Visual Studio 2017

I'm trying to (learn) publish a SQLCLR function using Visual Studio 2017. (It's a simple function that sends an email.) As a reference I used this articles on CodeProject and MSSQLTips: Create, Run, ...
-2
votes
1answer
41 views

How Can i Parse the sms text to textboxes [closed]

how can can i do this ? i can't get the return value and i can understand how regex work . string value = "+CMT:"+639231568462"," ","18/10/07,14:31:32+32" HELLO" "; Regex r = new Regex(""); ...
0
votes
1answer
157 views

Check if master is up from slave server(replication) postgresql

I want to check whether my master server is up by querying from slave server ? Is there any view or command ?
1
vote
2answers
101 views

Saving SSIS package from server to local computer

Right now I'm able to upload an SSIS package from my local computer to SQL Server with my C# program: Microsoft.SqlServer.Dts.Runtime.Application app; app = new Microsoft.SqlServer.Dts.Runtime....
0
votes
1answer
33 views

unable to add data to table because related record is required

I have an access database with my work that I am trying to insert into but I keep getting. 'You cannot add or change a record because a related record is required in table 'Projects'.' I'm running ...
1
vote
1answer
8k views

Before and After update trigger on same table

I have a table with 4 columns qty, qtydiff, price and value. I want a after update trigger that fires when qty row values change (more than one rows). The Before trigger should read and store the old ...
1
vote
0answers
56 views

increment row and calculate amount - follow up question

This is a follow up to my original question, but anyone can answer nonetheless. Increment each row according to condition in SQL C# WITH upd AS ( SELECT [Bill No], Item_Name, ...
0
votes
1answer
88 views

How to ensure that row with same PK inserted replaces old row in MS SQL Server, instead of throwing exception of PK Violation?

I'm transferring bulk data from a C# DataTable into a SQL Server DB. The DataTable provides values for all 26 columns except the first column, which is an auto-incremental ID The schema skeleton is as ...
1
vote
0answers
546 views

Oracle Number (10, 0) decimal in (C#) code

The following query is executed to add a new column to an existing table: ALTER TABLE TABLE1 ADD COLUMN1 NUMBER(10, 0) DEFAULT -1 NOT NULL. Using DBForge to check the database, result in NUMBER (10, ...
1
vote
2answers
47 views

How to provide a SQL Server database with a C# application [closed]

I am working on a C# application which depends on a few SQL Server databases. Now, in my development environment, I am using SSMS (SQL Server Management Studio) to create and manage my databases. My ...
2
votes
3answers
568 views

Should I use SSIS to write programming logic?

I have come across a fairly complex system where the business logic is written in SSIS. Since SSIS is not able to perform a big portion of this logic, it is heavily dependent on C# script tasks to ...
2
votes
0answers
242 views

SSIS Script Component Not Logging

How can I log from within an SSIS Script Component? I am using the below code, which I believe should work. public override void PreExecute() { this.Log("Entering PreExecute()", 0, new byte[0]); ...
0
votes
1answer
593 views

how do you output a plsql array via ref cursor

I have a legacy procedure that returns a plsql assoc table to a C++ DLL. Now I need to call it via C# and ODP.NET. I have been unable to find any info on how to call a proc that returns a pl/sql ...
0
votes
1answer
88 views

Select data from a table and update a second table using most recent value [closed]

I have two table: Stampings and Registries. Stampings is populate from a program that read a CSV file and do an insert into the table. Some field into the table are: name, surname, card-code and ...
0
votes
1answer
114 views

Regular data transfer from SQL Server to MySQL

Our company uses an application with a SQL Server database where we store all of our Project Item data. Our company's Portal Website uses a MySQL database that holds other Project information (...
0
votes
3answers
82 views

SQL Server FullText searching on text that is slightly obfuscated before insert

Our app slightly obfuscates text before insertion to the database. This is done by the application (C#) and not the database. (This is not encryption but just to stop people who are looking at the ...
1
vote
1answer
598 views

What is the “Default Timeout” value in SQLite connection string used for?

I have looked at the SQLite documentation and I can't find anything clear about the value "Default Timeout". Looking at other websites, it seems to refer to some sort of "Connection timeout", while ...
1
vote
0answers
306 views

C# Windows Service task fails due to a SP timeout, but works fine after executing the SP in SSMS

I have a Windows Service app running and sometimes a task which has a method call to a stored procedure (with a Select operation) is keep failing due to a timeout. But when I execute that SP with ...
7
votes
1answer
418 views

Why would a foreign key from a table to itself cause a deadlock when running two deletes?

I have a database with a table "SelfRef". SelfRef has two fields: Id (guid, PK, not null) SelfRefId (guid, nullable) There is a foreign key constraint that maps the SelfRefId field back to the Id ...
0
votes
1answer
650 views

Create a maintenance plan for sql database with C#

We are planning to create c# jobs that perform some database maintenance actions such as backup, shrink files etc... I have read in many blogs that database shrink is not recommended and thats why I'...
1
vote
1answer
43 views

Joining tables on DB server vs App-Backend server

I have two tables stored on the DB server. I need to join these two tables and perform further calculations. I am sure that the calculations part should be done on backend server. But I am wondering ...
3
votes
3answers
1k views

AddWithValue performance and plan cache implications

Recently I noticed my company's application using AddWithValueto pass parameter values to dynamic, parameterized queries. Example: cmd.Parameters.AddWithValue("@VehicleId", Vehicles.VehicleId); In ...
0
votes
1answer
188 views

What is a staging table and how do you protect data loss when transferring the data?

What is a staging table? What is it used for? Are there best practices that should be applied? I'm working in Oracle right now. Are staging tables platform dependent? I'm performing a bulk copy with ...
6
votes
3answers
6k views

Pass datatable as parameter in PostgreSQL

I have one datatable in asp.net C#. And I want to pass that datatable into PostgreSQL function as a table parameter. How is it possible? Below example is same but it is in SQL Server. I need same ...
1
vote
0answers
159 views

SSIS log subcomponent name

I want to log information using a 2016 SSIS C# (2015) script task that will be easily findable in my SSIS reports I have built. My plan is to use the IDTSComponentEvents.FireInformation method, and ...
0
votes
1answer
265 views

Arithmetic Overflow at RunningPackages (SSIS) problem [closed]

I've developed an SSIS Package with the C# Code.All the Package were running fine.But for the past 2 days, we are experiencing public void Main() { // TODO: Add your code here ...
1
vote
2answers
2k views

SQL Server Order SELECT List with condition

I want order the select list with condition. For example; I have t1 table and it has 3 columns and 6 rows Table t1: +----+---+---+ | id | x | y | +----+---+---+ | 1 | a | 1 | | 2 | b | 3 | | 3 |...
3
votes
1answer
2k views

Unable to connect using Azure AD Service Principal on SQL Server

I'm having trouble testing a connection to Azure SQL Server using SSMS with an active directory service principal. I have an AD Admin account created, and have successfully added a colleague's AD ...
-3
votes
1answer
97 views

SQL Server database chooser

I remember I used to use a tool that displayed a form so that any reachable database could be selected, like the initial prompt when you open SSMS. I don't remember if it's a StackOverflow tool, ...
2
votes
0answers
477 views

What to do when you find slow running query?

I have two databases. One with 10.000 rows and one with 10 million rows. I have a load test and I am running it towards a rest api endpoint. This endpoint does a query to database and average ...
-1
votes
2answers
536 views

Get compressed data from sql server database to application

I have created a C# application. I have used sql server database for this application. When i run the application it communicate with the sql server and retrieve data. My problem is that when ...
0
votes
1answer
685 views

OleDBConnection.Close() very slow on server

I am working on a few applications which connect to an MS Access database backend (.mdb) to read/insert/update records. Everything is working fine, but I noticed that my db operations were quite ...
1
vote
1answer
2k views

Asynchronous database inserts from C# always result in a deadlock

I'm hoping this doesn't come off as too amateurish, but I'm converting a synchronous program to run asynchronously. So far, I've gotten everything running asynchronously except database inserts. ...
0
votes
1answer
338 views

Query fails from application but runs fine in SSMS

I have a query that runs fine when executed from SSMS but when done so from the application, it fails with a (database level) exception. select ksprintid from kshistory_akt h where cast(h.serialno as ...
7
votes
2answers
1k views

Why can't C# SMO see extended properties on a column but Powershell SMO can?

I am attempting to read extended properties on tables and columns in a winforms C# application. I am using SQL Server SMO to do so. When I execute the application it does not see the extended ...
3
votes
2answers
520 views

Can add one CLR function to SQL server but not a second in the same assembly: loading wrong DLL

With the following code, I used csc to compile the dll. I then added the assembly to sql server 2014 using CREATE ASSEMBLY ReplaceMultiWord from 'd:\bcp\ReplaceMultiWord.dll' WITH PERMISSION_SET = ...
0
votes
4answers
131 views

Speed to read small table

I am trying to react to a Sql Table change very quickly. I have set-up a SqlDependency in c# and on receipt I query the table for "New" records. My table contains a few thousand rows. There are 2 ...
3
votes
2answers
2k views

A Dynamic where clause in MS SQL Server

The Problem My SQL Server database contains a view that looks like the following: +-------------+-----------+------+-------+------+------+ | CAR_ID | MAKE |COLOR | Miles | Seats| MODEL| +--...