Open in app

Sign In

Write

Sign In

Shahar Shokrani
Shahar Shokrani

10 Followers

Home

About

Mar 15

Solving the “The given value of type String from the data source cannot be converted to type nvarchar of the specified target column” issue

If you’ve ever encountered the error message “The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.” when working with a database, you know how frustrating it can be to debug. This error message typically occurs when there is…

Sqlbulkcopy

1 min read

Sqlbulkcopy

1 min read


Aug 4, 2021

Factory Design Pattern (Part 1)

Factory design pattern is a creational design pattern, judging by its name it sole purpose is to create (or instantiate) objects, yet another main benefit its you don’t have to worry about the creational process what so ever, by saying “you”, it means that your current context of code can…

Design Patterns

5 min read

Factory Design Pattern (Part 1)
Factory Design Pattern (Part 1)
Design Patterns

5 min read


Jul 21, 2021

Identity Server: How to retrieve access code and access token

This demonstration for identity server is using https://demo.identityserver.io/ (code flow with public client): client id: interactive.public grant type: authorization code with PKCE and client credentials access token lifetime: 60 minutues allowed scopes: openid profile email api offline_access Get the access code: In order to get the access code you should first refer to the…

Identity Server

2 min read

Identity Server: How to retrieve access code and access token
Identity Server: How to retrieve access code and access token
Identity Server

2 min read


Jun 23, 2021

Implementing azure functions with storage queue

Study Case + Tutorial — The Problem: We were trying to implement a solution that runs periodically (once in a week) and calls to an external api with 1,500,000 items metadata “{{domain}}/items”, then trying to figure out for each of the items if it needs to be updated or inserted to the database according by some arbitrary…

Azure Functions

2 min read

Implementing azure functions with storage queue
Implementing azure functions with storage queue
Azure Functions

2 min read


Feb 21, 2021

Interview Question: Design a low level RSS feed

Really Simple Syndication or RSS is a web feed, that allow users to be notified when a website is update a specific topic. For example: for a news website, like (https://www.ynet.co.il/), Jenny would like to be notified when there is a travel update or a politics update. …

Interview Questions

2 min read

Interview Question: Design a low level RSS feed
Interview Question: Design a low level RSS feed
Interview Questions

2 min read


Feb 13, 2021

SQL Server: Demonstrating Dirty-Reads

Isolation (The I in ACID), is a term that ensures that concurrent execution of transactions leaves the database in the same state that would have been obtained if the transactions were executed sequentially (wiki). In other words, if you do the operations again with the same base data the outcome…

Sql

3 min read

SQL Server: Demonstrating Dirty-Reads
SQL Server: Demonstrating Dirty-Reads
Sql

3 min read


Dec 6, 2020

Why Results Handlers are useful?

I would like to demonstrate a good practice for handling results, through this simple snippet of code (validation if a user has been approved or not) : public bool CheckIsApproved(int userId) { try { User user = this._userRepository.GetUserById(userId)…

2 min read

2 min read


Nov 17, 2020

Mediator vs. Observer

The Mediator and the Observer has some similarities, and can be very easily confused, in this post I would like to demonstrate their differences by two useful examples: 1. Chat application. 2. Emergency ambulance operator application. Chat application (Mediator design pattern) The mediator design pattern wikipedia definition is: With the mediator pattern, communication between objects…

Design Patterns

4 min read

Mediator vs. Observer
Mediator vs. Observer
Design Patterns

4 min read

Shahar Shokrani

Shahar Shokrani

10 Followers
Following
  • Tobias Streng

    Tobias Streng

  • Chameera Dulanga

    Chameera Dulanga

  • Erik Devaney

    Erik Devaney

  • Pooya Amini

    Pooya Amini

  • Devora Roth Goldshmidt

    Devora Roth Goldshmidt

See all (30)

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech