Explore tweets tagged as #sqlconnection
@hypeartistmusic
Hypeartist
2 years
Auto closing SqlConnection... #dotnet #csharp #SQLServer
4
1
9
@punhubdaily
the family guy
2 years
Want to manage your SQLConnection efficiently in #CSharp? 1. Create a static class Database. 2. You can even get the connection string from appsettings.json as well. 3. Create a connection property with a return type of SqlConnection.
0
0
0
@casperOne
Nick ➡ OFL👑/FGC Stats Daddy @ #EVO2024 BLM/ACAB
3 years
Be me: google "sqlconnection getschema calculated column" Also be me: First result on Stack Overflow is a question with an accepted answer from me
0
0
2
@Joysonpinto77
StreakLogic
2 years
0
1
4
@aryann_dev
Aryan Raj
1 year
🚀 Today's Project Update: Designed a signup page and added user attributes. Configured SQL Server 2008; it was a lengthy process. Encountered an error with SqlConnection while coding the signup function. Tried resolving it but failed. 🔄 Plan: Debug tomorrow! 💡 #CodingJourney
1
0
1
@kencharos
kentaro.maeda
2 years
ちなみにSuperCommonBase にはsqlConnection を取得する処理がコンストラクタに書いてあって、真面目に逃げる��とを考えた。
1
6
21
@JOrjuelaa
Juan Orjuela
19 days
@AngieMatiz6 @Fran14RP Eso me huele a Visual Basic con sqlConnection. Queries infinitos construidos en un string.
1
0
1
@gakuzzzz
がくぞ
2 years
SuperCommonBaseかっけー! さすがにsqlConnectionを取ってるのは問題だけど extension method が無い言語だと SuperCommonBase 的な実装継承させたくなるのもちょっとわかる…… default methodのある今ならinterfaceでも良さそうだけど。 IdOpsとか実は似たようなものだよね
2
2
4
@xin9le
じんぐる (Takaaki Suzuki)
8 months
.NET の Object を SQL Server に対して超簡単に Bulk Insert するためのライブラリを作りました🚀 https://t.co/RM8iXtSff4 --- これだけ!! --- using var conn = new SqlConnection(...); var count = await conn.BulkInsertAsync(records, options: default, timeout: null, cancellationToken);
1
9
54
@sockworkwet
ⒸⒶⓃ
3 years
@0xfcode SqlCommands, SqlConnection’lar neler oluyor orada öyle.
1
0
1
@awakecoding
Marc-André Moreau
7 months
SQL Server, why are you like this? After a month-long investigation after an upgrade of Remote Desktop Manager caused disconnections with SQL Server for Linux, we found the culprit: SqlConnection.PacketSize set to 8000 by default:
2
4
20
@senioregoist
***h
11 months
Küçük Bir Bilgi📌 SqlConnection sınıfı, SQL Server veritabanlarına bağlanmak için kullanılır.
0
0
10
@theo_albers
Theo Albers '67
2 years
@mjovanovictech I would strongly suggest to read the original article, https://t.co/xUFl9zOACi. Your example seems like a variant of the examples in the Microsoft article, but the contexts don't share the explicit SqlConnection...
0
0
0
@HzTumakov
Andrew Tumakov
1 year
@BassistAxel Ну да, сначала юзаешь голый SqlConnection и DataReader, а потом у тебя уже куча хелперов, и своя поделка типа даппера в каждом проекте)
0
0
1
@arupakattu
桜井天
2 years
今度の案件で https://t.co/90KNZhWl9y使うみたいだから調べてるんだけど、 SQL serverに接続するときの OleDbConnectionクラスとSqlconnectionクラスの差異がわからん どっちでもええんか?
2
0
0
@JP_sansan
ドンペイ.slnx
3 years
.NETのSqlConnectionてSQL Serverに接続するからSqlConnectionなんだな。初めてまともにDB接続のコードを書いたのがSQL Server向けのコードだったからずっと気付かなかった。紛らわしい製品名だわ。
0
0
0
@MyNameIsMurray
Murray
2 years
Okay, that's a super annoying issue. So I've been using old-school PowerShell SqlConnection + SqlCommand + DataTable method in my PowerShell scripts for some time, and it's a mess. The Invoke-Sqlcmd way is much better, via the SqlServer module... but version 22.x is BROKEN!
1
0
1
@garevaul
Bikramjeeth Garevaul
20 days
@JasonChlus @JasonChlus I have been convinced by @shayrojansky in this thread that using Password in SqlConnection class is NOT Secure and NOT the future. So I think No point in posting the question at Developers Forum, because the query was regarding the Password itself. What do you say ?
@shayrojansky
Shay Rojansky
26 days
@garevaul @condrong Yes, that's intentional. Even if SqlConnection accepted char[]/byte[]/Span<byte>, it wouldn't prevent the password from being dumped from memory - those are exactly the same as string.
0
0
0
@RobKeimig
Rob Keimig
2 years
@thdxr This is what we are starting to do w/ SQL Server Hyperscale. One gigantic namespace for everything. We are considering using RLS to scope rows based upon a tenant identifier supplied in the SQLConnection instance.
1
0
0