Preventing website from sql injection [on hold]

57
February 10, 2017, at 04:40 AM
  1. Use sql parameter in code instead of straight query
  2. Use store procedure
  3. Don't not give direct access to read a table use view or store procedure to call the table it might increase the performance of query
  4. Proper closing the resources like result set and connection in every circumstances
  5. Send and receive the data in encrypted

Apart from this, is there any better way to deal sql injection attach in c#.net?

READ ALSO
How can I optimize a query which depends on both COUNT and GROUP BY?

How can I optimize a query which depends on both COUNT and GROUP BY?

I have a query which purpose is to generate statistics for how many musical work (track) has been downloaded from a site at different periods (by month, by quarter, by year etc)The query operates on the tables entityusage, entityusage_file and track

43
How to solve subquery returns more than 1 row error?

How to solve subquery returns more than 1 row error?

I know that I need to rework this with IN but i can't do this correctlyPlease help me with this query

72
I have created a trigger to delete from 2 tables. How do I execute the trigger?

I have created a trigger to delete from 2 tables. How do I execute the trigger?

So I have 2 tables1 is golf courses, the other is each hole on those courses

69
Concatenating two columns in SQLite and having only one carriage return

Concatenating two columns in SQLite and having only one carriage return

I am trying to concatenate two columns into one and managed to do itBut I dont want a carriage return for two columns, instead want only one with a space between two columns

46