Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var connectionString = RegistryReader.GetFixedConnectionStringFromRegistry();
- using (var connection = new OracleConnection(connectionString))
- {
- //Dla uproszczenia, usuwam poprzednie przyklady z tabeli
- connection.Execute("DELETE FROM GUID_TEST_TABLE");
- //Najbardziej przystepny, niezyciowy GUID
- var testGuid = Guid.Parse("00112233-4455-6677-8899-AABBCCDDEEFF");
- Console.WriteLine($"GUID testowy: {testGuid}");
- //Wprowadzam GUID do tabeli
- connection.Execute($"INSERT INTO GUID_TEST_TABLE (ID) VALUES ('{testGuid.ToString("N")}')");
- //Odpytuje baze danych
- var rawBytesFromOracle = connection.Query<byte[]>("SELECT * FROM GUID_TEST_TABLE").Single();
- var guidBuiltFromOracleBytes = new Guid(rawBytesFromOracle);
- Console.WriteLine($"Ten sam GUID po wyjeciu z Oracle: {guidBuiltFromOracleBytes}");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement