Reputation
3,874
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
11 20
Impact
~209k people reached

Feb
2
comment How do you integrate separate projects into a single solution?
You could set up a internal Nuget repository and put common/framework projects in there. Then it's pretty easy to share and re-use components in that fashion.
Jan
29
awarded  Sportsmanship
Jan
28
answered Cleanup & Arrange practices during integration testing to avoid dirty databases
Jan
15
comment Best practice for getting last record inserted in DB
If you want to fool around and turn off identity inserts or run a DBCC CHECKIDENT to reset the identify column one can insert the same number more than once. If inserting records in a table, the identity column will work nicely because the database will automatically increment the identity without any additional effort. The comment should be amended to say. the next number will not be the same as the previous. But for practical purposes, it will be unique provided it is not tampered with.
Jan
15
comment Best practice for getting last record inserted in DB
How's a thread.sleep(1) going to help? If you wait a second and then the next second you can have a collision as well. Use the identity column, it's guaranteed to be unique and auto increments. Dates not so much. You could put a unique constraint on the date column, but you will run the risk of constraint violation and then re-running the transaction again back to the database if that occurs. Avoid that complexity.
Jan
15
answered Best practice for getting last record inserted in DB
Jan
15
comment How is rendering a Word document different from rendering a website?
@Bakoyaro - I was wondering why as well, basically you have format X and format Y. Although both formats use markup and tagging to describe the document, the specifications are different.
Jan
14
revised Methods of debugging code (Nightmare situation)
added 71 characters in body
Jan
14
answered Methods of debugging code (Nightmare situation)
Jan
14
comment How is rendering a Word document different from rendering a website?
Thanks, updated answer slightly.
Jan
14
revised How is rendering a Word document different from rendering a website?
added 263 characters in body
Jan
14
answered How is rendering a Word document different from rendering a website?
Jan
6
comment Differences between `throw` and `throw new` and exactly how exceptions “bubble up”
I agree it is not optimal. Ideally I think it could return an int and then you could have a validator (class) to validate the result afterwards returning a true/false answer thus eliminating the intermediate class. But, I was mainly trying to show the avoidance of using exceptions to control flow.
Jan
6
answered Differences between `throw` and `throw new` and exactly how exceptions “bubble up”
Jan
6
revised Designs and practices to guard against erroneous null entries from database
deleted 3401 characters in body
Jan
6
comment Designs and practices to guard against erroneous null entries from database
Ahhh, I will update my answer based on this.
Jan
5
comment Designs and practices to guard against erroneous null entries from database
If someone wants to post the equivalent Java version that would be great...
Jan
5
comment Designs and practices to guard against erroneous null entries from database
Marking them as NOT NULL in the database would be the best solution, if a column is nullable, then the code will need to handle the case when it is, even if it is not expected because the storage mechanism allows it.
Jan
5
answered Designs and practices to guard against erroneous null entries from database
Jan
4
answered How to prevent user from requesting API method multiple times in parallel?