Skip to content Skip to sidebar Skip to footer
Showing posts with the label C#

How Can I Get The Definition Of A Sql Clr Function From The Database

The code I was given for an SQL CLR project contains one function where the .net implementation is … Read more How Can I Get The Definition Of A Sql Clr Function From The Database

Overriding Validateuser() With Sqlmembershipprovider And Custom Sql Database

I wish to use an SQL database that it already in use on my network, so I have written code to overr… Read more Overriding Validateuser() With Sqlmembershipprovider And Custom Sql Database

"must Declare Scalar Variable" Error

Must declare the scalar variable '@Id' SqlConnection con = new SqlConnection(@'connect… Read more "must Declare Scalar Variable" Error

Getting An Sql Connection String Error When Scaffolding In Ef Core?

For background info, I'm running .NET core on Arch Linux VScode and I also have SQL Server runn… Read more Getting An Sql Connection String Error When Scaffolding In Ef Core?

Sql Server Where Clause Equals Instead Of In

Here is the generated T-SQL from LINQ SELECT [Extent1].[ID] AS [ID], [Extent1].[Name] AS … Read more Sql Server Where Clause Equals Instead Of In

What Is Best Approach For Opening/closing Sqlconnection In C#

I would like to know what could be best approach to open a SqlConnection with Sql Server 2008R2 Exp… Read more What Is Best Approach For Opening/closing Sqlconnection In C#

Specified Cast Is Not Valid Error Using Asp.net?

here is the error that came up after attempting to execute my website. This is related to my previo… Read more Specified Cast Is Not Valid Error Using Asp.net?

Lock A Sqlite Database For Reading From C#

My Projects has c++ dll in which a db is created in Sqllite with share deny = none . This dll will … Read more Lock A Sqlite Database For Reading From C#