All Questions
Tagged with sql-server-2005 c#
1,231
questions
0
votes
1
answer
80
views
Auto applied migrations using EF Core 7.0.14
When I make a new migration (Add-Migration Example) , and then I try to get all the migrations (Get-Migration) I find that the "applied" field is "True" without even using (Update-...
0
votes
1
answer
66
views
Entity Framework Remote SQL Server
I have 2 machines, one that have an SQL Server with all the data in it, and another one that has the client dashboard.
Both machines are not physically in the same location, so the Entity Framework ...
- 316
1
vote
1
answer
2k
views
When is DbContext.Entry(enttity).State = EntityState.Modified; required?
I want to clarify when I need to set the EntityState with Entity Framework Core.
Context: code-first C# Blazor Server App, SQL Server database.
Consider:
public async Task UpdateHelper(Helper ...
- 572
1
vote
2
answers
729
views
How can I insert a value into a table where the column contains special character?
I would like to insert a record into an MsSql data table. It is an easy thing, but the target table contains special naming columns like:
<"mz,x",int>
Unfortunately I cannot rename the ...
- 35
0
votes
2
answers
1k
views
Update only the given values (Entity Framework)
I am trying to update the entity only by the values sent to the API dynamically, so each time the client will send to my api different values it will change only the given values.
This is my entity
...
- 303
0
votes
2
answers
267
views
How can I change .Designer.cs in C# project?
this._commandCollection[4].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ILBO_ST41", global::System.Data.SqlDbType.NVarChar, 10, global::System.Data.ParameterDirection....
- 49
0
votes
1
answer
168
views
How to make a T-SQL query where the first letter of the output equals to a character
I would like to know if there is a way to make a query where the output is stored in a local variable and IF condition is used to check if the first character if the output matches to a character
...
- 109
0
votes
0
answers
53
views
User Instance uses Path for database name when attached in SSMS
When I attached my database to SQL Server Express, my database name got changed to my database address. Can someone help me to figure this out?
Here is a screenshot:
- 1
0
votes
1
answer
45
views
Adding Query result to label string
I have a label that I want a standard message to display "Today's Total: " how would I add my query result to the end of that string on the label.
var sql = @" SELECT COUNT (RTFPressTableID) AS ...
- 15
0
votes
0
answers
109
views
Data Migration - SQL Server
I have a problem with a data migration. I will try to give all the information to help me solve this situation. A little of history:
In 2005 an internal website was developed to help manage its ...
-1
votes
1
answer
647
views
What is the equivalent of SQL Server 2005 IMAGE Datatype in C#
I have a stored procedure that I am calling in C# in data layer. So it has many parameters and one of which is bytes array
byte[] value
However, the column in the stored procedure and hence the ...
- 5,286
0
votes
1
answer
457
views
SQL: .. contains an unresolved reference to an object
Full message
Parameter: [DbName].[SpName].@timeout contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the ...
-1
votes
1
answer
1k
views
How to insert List<string> into SQL Server table as object?
I make & use a datatable with a column through
test_dt.Columns.Add("list_paragraphs", typeof(List<string>));
In this way, I just need 1 row to save List<string> object which has many ...
- 932
0
votes
0
answers
150
views
Connect to SQL Server 2005 with trusted connection and username
I want to connect to MS SQL Server 2005 in my C# application.
The SQL server is running on a remote machine.
I want to connect to the SQL server by using trusted connection (=a requirement by the ...
- 175
0
votes
2
answers
170
views
C# Game Server with SQL Server database error
I have a game server. It's written in C# with SQL Server 2005. The server is doing fine for about an hour or so, but then something happens, a database error. I am not too much into C#, so I am not ...
