Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [c#]

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

-3
votes
1answer
20 views

SQL Select Query [closed]

tablename=master Date |car_id | car_type| Qty | Amount ---------+-----+----------+---------+------------ 05/06/19 | 100421 | X | 1 | 10 05/06/19 | 100421 | ...
0
votes
1answer
32 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
30 views

NpgsqlException: ERROR: 22P02: invalid input syntax for type json [migrated]

I have the following JSON string: {"packedRecipeType":"DynamicCharacterAvatar","name":"Character","race":"HumanFemale","dna":[{"dnaType":"DynamicUMADna","dnaTypeHash":1932961400,"packedDna":"{\"...
0
votes
0answers
18 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 ...
1
vote
2answers
6k views

Table Design for Student Attendance hourly for each day

I have created a table (attendance_details) for storing every day attendance of Students in MySQL. Need to capture attendance for hourly (1-8hrs) every day. I have the student details in separate ...
0
votes
0answers
20 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
80 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
108 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
4answers
123 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 ...
0
votes
1answer
35 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
33 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 ...
0
votes
1answer
198 views

In which extent can I use the Oracle Data Provider for .NET Managed Driver?

Good evening everybody, I am planing to dive into the oracle database world. Additionally, I want to develop some tools, which make my life easy by checking and modifying information in different ...
2
votes
1answer
222 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, ...
1
vote
1answer
560 views

Could I use the SQL statement, SELECT * from sysobjects, with C# MySQL Connector - .NET?

I would like to port a SQL statement, SELECT * from sysobjects, written for Microsoft SQL Server to MySQL version 5.6. Could I use the SQL statement, SELECT * from sysobjects, with C# MySQL ...
1
vote
1answer
559 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 ...
-2
votes
1answer
37 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
133 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 ?
0
votes
1answer
653 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
2answers
91 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
30 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
7k 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
66 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
470 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, ...
0
votes
0answers
40 views

How to backup only primary filegroup ?

I need to exclude one of my table in database during backup. So I move the table to another filegroup "SECONDARY". bkpDifferential.Action = BackupActionType.Files; bkpDifferential....
1
vote
2answers
46 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
529 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
227 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]); ...
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 |...
0
votes
1answer
544 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 ...
2
votes
0answers
381 views

Intermittent IOExceptions when connection with MySQL Connector/Net. Why?

I have a web application which uses a MySQL 5.7.13 server for storing its data. MySQL is running on Windows Server 2008 R2. A couple of month ago I started seeing exceptions like the following being ...
4
votes
4answers
18k views

Trying to connect to PostgreSQL with Entity Framework via Npgsql and C#

So, I'm new to databases and only have done a little with PostgreSQL before. I have C# (visual studio 2012) and have downloaded the Entity framework (6). I have also downloaded the latest Npgsql data ...
0
votes
1answer
79 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
3answers
79 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
0answers
291 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
399 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 ...
2
votes
1answer
467 views

Sleeping connections

I have a dedicated MySQL server(8GB) with following configuration. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql lower_case_table_names = 1 default-storage-engine=...
1
vote
1answer
35 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 ...
0
votes
1answer
617 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'...
2
votes
3answers
958 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
163 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 ...
5
votes
2answers
1k views

What's the best practice of inserting a collection of data into a SQL Server database

I am using C#, Entity Framework. SQL Server for the development. I have a method which has two parameters (int ID, List<String> _listobj). For each ID, there is a list of obj. All of these IDs ...
1
vote
0answers
150 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 ...
6
votes
2answers
14k views

sql server , set N prefix as unicode for all queries by default

Is there any option in ms sql server which use N prefix for my database. There are many query in my application which non of them use N prefix for nvarchar fields , and now I have to set N for all of ...
0
votes
1answer
255 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 ...
2
votes
2answers
48 views

Report individual changes to data

I need to produce a daily extract on the individual changes to a dataset. So, there are 14 tables containing product and customer information and the extract must only show records from each table ...
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 ...
4
votes
2answers
687 views

Timeout expired SqlException for complex Procedure

I use Sql Server 2008 R2 and ASP.NET 4.5. Sometimes, I get this error when I executed a complex procedure: System.Data.SqlClient.SqlException Timeout expired. The timeout period elapsed ...
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 ...